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