>>>>Hi All
>>>>
>>>>Having a bit of a blind moment. I am trying to connect to a MySQL database that a contract programmer has given me without much documentation. Here is my test connection code:
>>>>
>>>>

>>>>lcServer   = "localhost"
>>>>lcDatabase = "MyTableName"
>>>>lcUser     = "root"
>>>>lcPassword = "MyPassword"
>>>>
>>>>lcStringConn  ="Driver={MySQL ODBC 3.51 Driver};Port=3306" + ;
>>>>              ";Server="   + lcServer   + ;
>>>>              ";Database=" + lcDatabase + ;
>>>>              ";Uid="      + lcUser     + ;
>>>>              ";Pwd="      + lcPassWord
>>>>              
>>>>lnHandle=SQLSTRINGCONNECT(lcStringConn)
>>>>

>>>>
>>>>But I get a connection error which says: "Connectivity error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
>>>>
>>>>The contract developer says my connection string is right but clearly I cant connect. Where am I missing the obvious?
>>>>
>>>>TIA
>>>
>>>
>>>Looks, OK - but you do specify the name of the database and not just a tablename, don't you ?
>>
>>Hi Gregory, sorry, in my example "MyTableName" should have been "MyDatabaseName". Sorry. I feel I am missing something obvious but cant think of it right now!
>
>
>Maybe a 32/64 bit issue
>
>Try run C:\Windows\system32\odbcad32.exe and define a user DSN and see whether you can connect

I ran odbcad32.exe and tried to create a user DSN but again it fails with "Connection failed. ... Cant connect 'localhost' (10061)"

I looked under drivers and see 2 MySQL drivers as follows:

MySQL ODBC 5.3 ANSI Driver
MySQL ODBC 5.3 Unicode Driver

If I change my connect string to reflect the first one I still get the same failure.

This is a Windows 2008 R2 64 bit server.