>>
>>This is a Windows 2008 R2 64 bit server.
>
>(1) your connectionstring seems to be missing a semicolon after lcPassword
>(2) see whether you have the 3.5 drivers under 64 bit odbc
>(3) try to connect (set up a dsn) via 64 bit odbc
>
>The connection string for 5.3 is different
http://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-without-dsn.htmlHi Gregory,
I ran the ODBCAD32.exe again and was just experimenting with different settings to see different error messages. I changed the port from the default 3306 to 3307 and voila it connected OK - "connection successful". So I have the right username/password and now the right port. So that works. But from VFP it does not. I keep getting a "Data source name not found and no default driver specified".
I have change the code to add the semi-colon after the password. And changed the MySQL driver name as per the example.
lcStringConn = "Driver={MySQL ODBC 5.3 Driver}" + ";" + ;
"Port=" + lcPort + ";" + ;
"Server=" + lcServer + ";" + ;
"Database=" + lcDatabase + ";" + ;
"Uid=" + lcUser + ";" + ;
"Pwd=" + lcPassWord + ";" + ;
"option=3" + ";"
But it still fails. Could it be a VFP/32bit vs. MySQL 64bit driver issue?
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.