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

Troy,

Apparently the providers do not support asynchronous connection. How about
using ADO in ActiveX task and setting up synchronous connection?

Ilya

"Troy Jerkins" <tjerkins (AT) alltel (DOT) net> wrote