mysql replication

1 Way trans. replication to a mysql database
SQL Server Env:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Windows NT 5.0 (Build
2195: Service Pack 4)
Distribution Agent:
Error Details:
Invalid cursor state
(Source: ODBC Driver Manager (ODBC); Error number: 24000)
Last Command:
select xactts, subguid from MSrepl7 where pubsrv = ? and pubdb = ? and
indagent = 0 and subtype = 0
I've searched the newsgroups but this doesn't apply to my build ver.
http://support.microsoft.com/default.aspx?kbid=831997
I'm logging in as a mysql super user, the remote tables have been created.
I'm using the newest MySQL ODBC 3.51 Driver
The problem recurs when you stop and start the agent and server.
are you replicating to a heterogeneous subscriber? There was a bug
associated with replicating to mysql where it would work until the
distribution agent failed or stopped. On restart you would get an error.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JD" <test@.test.com> wrote in message
news:%23yDKDHtFFHA.1936@.TK2MSFTNGP14.phx.gbl...
> 1 Way trans. replication to a mysql database
> SQL Server Env:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Windows NT 5.0 (Build
> 2195: Service Pack 4)
> Distribution Agent:
> Error Details:
> Invalid cursor state
> (Source: ODBC Driver Manager (ODBC); Error number: 24000)
> ----
--
> --
> Last Command:
> select xactts, subguid from MSrepl7 where pubsrv = ? and pubdb = ? and
> indagent = 0 and subtype = 0
>
> I've searched the newsgroups but this doesn't apply to my build ver.
> http://support.microsoft.com/default.aspx?kbid=831997
> I'm logging in as a mysql super user, the remote tables have been created.
> I'm using the newest MySQL ODBC 3.51 Driver
> The problem recurs when you stop and start the agent and server.
>
>
|||Yes, I beleive that replication to mysql is only possible via a
heterogeneous subscriber
Is there anything I can tune or workaround to get this going ?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OeBrYx2FFHA.1264@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> are you replicating to a heterogeneous subscriber? There was a bug
> associated with replicating to mysql where it would work until the
> distribution agent failed or stopped. On restart you would get an error.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "JD" <test@.test.com> wrote in message
> news:%23yDKDHtFFHA.1936@.TK2MSFTNGP14.phx.gbl...
> ----
> --
created.
>
|||I've tried also tried it (just now) with snapshot replication...same deal
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OeBrYx2FFHA.1264@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> are you replicating to a heterogeneous subscriber? There was a bug
> associated with replicating to mysql where it would work until the
> distribution agent failed or stopped. On restart you would get an error.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "JD" <test@.test.com> wrote in message
> news:%23yDKDHtFFHA.1936@.TK2MSFTNGP14.phx.gbl...
> ----
> --
created.
>
|||My research indicates that currently there is not a
workaround for this issue. Hilary is correct, there is a
known issue with the distribution agent code. The
product team is looking at fixing this issue in the
future service packs but there is no specific timeline
right now.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
This posting is provided "AS IS" with no warranties, and
confers no rights.
--
>From: "JD" <test@.test.com>
>References: <#yDKDHtFFHA.1936@.TK2MSFTNGP14.phx.gbl>
<OeBrYx2FFHA.1264@.TK2MSFTNGP12.phx.gbl>
>Subject: Re: mysql replication
>Date: Sun, 20 Feb 2005 19:00:30 -0500
>Lines: 57
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
>Message-ID: <ecUB3c6FFHA.3840@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: 69.158.71.17
>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGP08.
phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.replication:59788
>X-Tomcat-NG: microsoft.public.sqlserver.replication
>Yes, I beleive that replication to mysql is only
possible via a
>heterogeneous subscriber
>Is there anything I can tune or workaround to get this
going ?
>
>
>"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in
message[vbcol=seagreen]
>news:OeBrYx2FFHA.1264@.TK2MSFTNGP12.phx.gbl...
There was a bug[vbcol=seagreen]
work until the[vbcol=seagreen]
would get an error.[vbcol=seagreen]
Windows NT 5.0 (Build[vbcol=seagreen]
24000)[vbcol=seagreen]
--[vbcol=seagreen]
= ? and pubdb = ? and[vbcol=seagreen]
to my build ver.[vbcol=seagreen]
http://support.microsoft.com/default.aspx?kbid=831997[vbcol=seagreen]
tables have been[vbcol=seagreen]
>created.
agent and server.
>
>