MySQL Forums
Forum List  »  Microsoft SQL Server

Running DTS between MySQL and MSSQL
Posted by: Troy Jerkins
Date: September 08, 2004 03:02PM

I'm trying to set up a DTS package between SQL 2000 (sp3a) and MySQL v.
I've installed both MyOLEDB3 and MyODBC on the SQL 2000 server and can make
a connection to MySQL just fine using both.

The problem is whenever I try to execute a SQL Task, I recieve the error
"Provider does not support asynchronous execution".

This is against any query I run it seems. I can run Bulk inserts Ok. Any
ideas to correct this problem?


Options: ReplyQuote

Written By
Running DTS between MySQL and MSSQL
September 08, 2004 03:02PM

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.