Hello Guys,

I'm trying to configure a Transactional Replication from SQL 2000 to MySql using MyODBC.

The problem:

When I try to add a new Subscriber, I receive the following message:

'ODBCMYSQL' could not be enabled as a subscriber because the ODBC driver for this data source does not provide sufficient functionality. Contact the vendor to obtain an updated ODBC Driver.

Error 2132: [SQL-DMO]The DSN is not a valid SQL Server Subscriber

You can't make MySQL replicate SQL Server. Replication only works MySQL to MySQL.

But,
I'm Trying to replicate SQL 2000 Database to MySql 5

Sorry about that. I have not set up heterogenous replication with SQL Server, but I do know that it will fail if Queued Updating or Immediate Updating are selected, it will fail. That is the extent of my knowledge on the subject.