Friday, March 23, 2012

replication problems sql server to db2

I am experiencing problems replicating (transactional) from SQL Server
2000 sp3 to DB2 v8.2 (running on Red Hat Linux).

I have created an OLE-DB linked server to DB2. The connection connects
successfully in EM and I can query the DB2 tables using the OPENQUERY
function.

I have successfully added the linked server connection as a Subscriber.
I have now set up a Push Subscription to DB2 from one of my
Publications.

My Distribution Agent errors with:
"The process could not connect to Subscriber xxx "

Any suggestions will help, thank youI have no idea myself, but you might get a better response in
microsoft.public.sqlserver.replication.

Simon|||I have no idea myself, but you might get a better response in
microsoft.public.sqlserver.replication.

Simon

No comments:

Post a Comment