>>>>>>>
>>>>>>>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
>>>>>
>>>>>Hi 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?
>>>>
>>>>
>>>>If it works with ODBCAD32.exe, I think vfp can handle that
>>>>
>>>>Can you specify a database in ODBCAD32.exe and see whether that is ok ?
>>>
>>>Gregory, so I got that User DSN created with the database. But I still cant get this to work in VFP. I think the driver parameter is wrong but I cannot find out what it should be. Is there a way to find it out via the MySQL Workbench program? The contractor installed that on the server and I have access to it. Seems to be MySQL version 5.1.73. But I cant find a driver description to use.
>>
>>
>>Try here, Jos - under 64 Bit Machine
>>It seems we need to point on MSDASQL for the (32 bit) ODBC driver to work on 64 bit machines.
>>https://www.connectionstrings.com/mysql-connector-odbc-5-1/
>
>Great resource for connection strings! Tried them all, none work. What is confusing is that the MySQL Workbench says its version 5.1.73. But under ODBCAD32.exe it shows "MySQL ODBC 5.3 ANSI (or UNICODE) driver". i.e. 5.3 ... I have tried with/without the word "ANSI", using versions 5.0, 5.1, 5.2, 5.3, with/without the "w", and with/without the "Provider". All return "Data source name not found and no default driver specified". Strange.

sorry, Jos - I don't have MySQL installed