How to set up replication from SQL Server 2005 to MySQL through ODBC

Hi,
Can anyone please provide me with a step-by-step explanation on how to
replicate data (snapshot replication) from a table in a SQL Server
2005 database to a table in a MySQL database through an ODBC
connection?
I have already created a publication, but have not succeeded in
successfully adding a subscription. I know that I have to use the
stored procedures "sp_addsubscription" and
"sp_addpushsubscription_agent", but cannot figure out how to set up
the parameters to get it to work. Any help on this issue would be
greatly appreciated.
Thanks
This is not supported in SQL 2005. It was in SQL 2000 but there was a bug
last time I checked.
<ronald.debruin@.ecorys.com> wrote in message
news:1177595848.403994.88300@.n35g2000prd.googlegro ups.com...
> Hi,
> Can anyone please provide me with a step-by-step explanation on how to
> replicate data (snapshot replication) from a table in a SQL Server
> 2005 database to a table in a MySQL database through an ODBC
> connection?
> I have already created a publication, but have not succeeded in
> successfully adding a subscription. I know that I have to use the
> stored procedures "sp_addsubscription" and
> "sp_addpushsubscription_agent", but cannot figure out how to set up
> the parameters to get it to work. Any help on this issue would be
> greatly appreciated.
> Thanks
>