Hi all.

What is the "OPTION=3 in connection string mean? what if I changed that number??

I am using Mysql.

sample:
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.Recordset")
Conn.Open "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=blahblah.com; DATABASE=b;lahblah_com_website; " &_
"UID=me;PASSWORD=you; OPTION=3"

Thanks.

Literally it means:
Option value 1: Client Can't handle the real columnwidth being returned
Option value 2: Have MySQL return found rows values

To answer your inevitable question, the reason there is no Option '3' is because 3 in your connection string is the sum of 1 and 2.

You can't change option to anything you want, however. This MySQL article should help you, just remember, OPTION is the sum of the options you are using.

http://dev.mysql.com/tech-resources/...-handling.html

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========