MySQL Forums
Forum List  »  Connector/ODBC

mysql run-time error (80040e21) Multiple-step OLE DB operation
Posted by: Miguel Jimeno
Date: January 06, 2005 02:37PM

I'm working with Visual Basic 6 connected to a MySQL 4.1 using this connection string:
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=server; DATABASE=re;UID=root;PWD=a;"
Then I make a simple select, like this:
SQL = "Select Name, Title, ... from Products where Active='" & con & "' order by Name"
rs.Open SQL, basedatos
where:
Public basedatos As ADODB.Connection
Public rs As ADODB.Recordset
And I get this error:
mysql run-time error (80040e21) Multiple-step OLE DB operation. Check each OLE DB status value, if available. No work was done.
Any idea how to solve it?
Thanx, M

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.