>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 ?