Hi,

I wonder how to set OPTION parameter when connecting to mysql database from ASP script using MyODBC connection string, like

constring = "Driver={MySQL ODBC 3.51 Driver}; SERVER=servername; "
constring = constring & "DATABASE=dbname; "
constring = constring & "UID=username; "
constring = constring & "PASSWORD=password;"
constring = constring & "OPTION=???;"

I read on mysql http://www.mysql.com/doc/en/MyODBC_c...arameters.html which are available connection parameters, but I dont know which one is (are) suitable for ASP.
On several my websites (hosted on one server) sometimes "Too many connections error" occures, could the missing OPTION parameter cause such a problem?

any help appreciated, thanks

Misha