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