A serious error occurred when connecting to the provider.

cupboy

This error appears when trying to use the mysql odbc connection in SQL Server 7's dts. I successfully did this on another system, but on the system I am on now this error occurs.

The username/password is ok, since if I put in a fake username or password it rejects that right away.

MarkR

I really think supporting the MS DTS wizard is outside the scope of this forum.

However, from my experience, I've found it an incredibly annoying, buggy piece of poo.

I recommend that you absolutely avoid using it under any circumstances:
- It often gets things wrong
- If you get some of the many parameters wrong, there is no way to go back and fix them, you must start again
- It saves its stuff in binary format
- There is no way to view all the parameters in one screen (or indeed, text editor form)
- It often fails for no reason

don't use it.

Mark