MySQL Forums
Forum List  »  Microsoft SQL Server

Migrating SQL Server to MYSQL in ASP/ADO
Posted by: Richard Manno
Date: January 12, 2011 01:23PM

I'm migrating my asp application from ms sql server to mysql. All views and stored procedures have been successfully modified and created in mysql without error.

When I use the application I get the following error:
--------------------------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 5.1 Driver][mysqld-5.5.8]Commands out of sync; you can't run this command now
--------------------------------------------------------------------------------
All the references to this error message I could find refer to clients that directly execute mysql functions. This, of course, is not the case with ASP/ADO as all such functions are executed behind the scenes.

I can't believe I'm the only one having this problem. Can someone please tell me what is causing the error?

Rich

Options: ReplyQuote


Subject
Written By
Posted
Migrating SQL Server to MYSQL in ASP/ADO
January 12, 2011 01:23PM


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.