OPTION values for MySQL5 SQLSTRINGCONNECT

[mbabcock]

Here's the connection string I use commonly with my VFP9 apps connecting to a MySQL5 backend:

DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;UID=mike;PWD=foxrocks;DATABASE=mydb;option=131609

I was wondering what other values for the OPTION parameter folks use? Sometimes, I get some flakiness, so I was searching for a consensus on "best option value to use."

tia!
--Michael

 

[Mike Lewis]

Michael,

Have you tried posting this question in the MySQL forum here on Tek Tips? You might get a faster answer there, given that the problem relates to MySQL and is not particularly FoxPro-specific.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk