OPTION value used from Visual Foxpro 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

 

[johnwm]

The values of each bit are detailed in

http://dev.mysql.com/doc/refman/5.0/en/myodbc-configuration-connection-parameters.html

which also gives a few recommended values for different applications.

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints