| Groups | Blog | Home |
sql server replication : mysql replication
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 [quoted text, click to view] "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 ? [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:OeBrYx2FFHA.1264@TK2MSFTNGP12.phx.gbl... > 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. > > > > > > > >
I've tried also tried it (just now) with snapshot replication....same deal
[quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:OeBrYx2FFHA.1264@TK2MSFTNGP12.phx.gbl... > 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. > > > > > > > >
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. -------------------- [quoted text, click to view] >From: "JD" <test@test.com> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.>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: phx.gbl!tk2msftngp13.phx.gbl [quoted text, click to view] >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 >news:OeBrYx2FFHA.1264@TK2MSFTNGP12.phx.gbl... >> 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) >> >> ----------------- [quoted text, click to view] >> --
>> > -- >> > 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. >> > >> > >> > >> >> > > >
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |