>>>>>>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.
>
>(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.html


Gregory, I shall try all that. Can VFP connect using 64bit driver being itself 32bit?