I found article about replicating MS SQL 2000 data and MySQL.
Here is link: http://blogs.techrepublic.com.com/howdoi/?p=112
I somehow forced them to work :-) but now I have 'Invalid cursor state' error.
Can anyone explain this part here:
" Simply create the MySQL system as a linked server (using the Microsoft OLE DB Provider for ODBC Drivers and the DSN you created). Then, create a replication alert for this error that will run a distributed transaction to the MySQL server instructing it to drop the table MSRepl7 and then restarting the distribution agent. This quick and simple fix will work wonders for your replication stability."
I created MySQL system as a linked server but dont know bold part.
Thanks...