I have been using MySQL since few weeks ago and I got this connection string from somewhere but I could not understand the OPTION thing.

Could somebody give a brief info about this?

and one more thing, is there any LockType (like in MS Access MS SQL) in MySQL?

Thanks..

Code: Select all

connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=mydatabase; OPTION=4; UID=root; PASSWORD=mypassword;"