Thought I might share this with others.
I recently upgraded MyODBC from 2.50-39 to 3.51.06
When I ran simple select statements from an ASP page in which the fields
were empty, I would get the following errors:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
I tried everything, until I realised that it could be due to MyODBC. So I
just changed the MySQL connection string to:
Conn.ConnectionString =
"Driver={MySQL};SERVER=xx;DATABASE=xx;UID=xx;PWD=x;PORT=3306;OPTION=16384;"
from this (which doesnt seem to work for some queries)
Conn.ConnectionString = "Driver={MySQL ODBC 3.51
Driver};SERVER=x;DATABASE=x;UID=x;PWD=x;PORT=3306;OPTION=16384;"
and bingo...it worked!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
