Running DTS between MySQL and MSSQL
I'm trying to set up a DTS package between SQL 2000 (sp3a) and MySQL v.
4.0.20a.
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?
-Troy
Subject
Written By
Posted
Running DTS between MySQL and MSSQL
September 08, 2004 03:02PM
September 28, 2004 09:20AM
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.