Access Denied For User

2005-02-23 Thread Dan Wareham
Hello, I have a Linux server running Apache, MySQL, unixODBC, MyODBC In my odbcinst.ini file I have the following: [MySQL] Description= ODBC for MySQL Driver = /usr/local/lib/libmyodbc3.so FileUsage = 1 I have setup the following system DSN in the odbc.ini file: [PbDatabase]

Re: Time in VBA for Excel

2005-02-16 Thread Dan Wareham
Hi Dan, Sorry for causing additional work to getting the test setup, I will take your advice should I need to post these type of details again With regards to your solution, it works perfectly!!! Great thanks for putting the time and effort in to help sort this problem. Much appreciated. I

Re: Time in VBA for Excel

2005-02-15 Thread Dan Wareham
Hey Dan, Thanks for the post and the code ideas. Unfortuantely I still can't get the thing to work even when trying the CONCAT and CAST functions. As per your request, here is the details of what I have got so far: I'm running MySQL 4.1.9 with MyODBC 3.51. The table in question is the Users

Time in VBA for Excel

2005-02-14 Thread Dan Wareham
Hello, I have a table in my database with two fields set as Time types. The issue I seem to have is when I use an ADO connection in VBA for Excel to select the two fields. Instead of the expected format HH:MM:SS held within my recordset, I get the current date in the format DD/MM/. Then

Exporting Replication

2002-07-18 Thread Dan Wareham
Hello Everyone!! I've just joined this list and have already started to enjoy the various threads that are running. I also wanted to get some feedback on something that I'm trying to do. I have currently developed a survey system that uses a mysql database that consists of 15 tables. The