Post reply

Replication to DB2

  • August 17, 2005 at 9:17 pm

    #90560

    Hi,

    I am trying to setup Replication from SQL Server to DB2.  I have created a Publisher, added an ODBC data source for my DB2 database, and enabled my DB2 database as a subscriber.  However, when I try to create a "push subscription", I get an error message saying "error 21060 could not subscribe because non-SQL server subscriber "pubs" does not support parameterized statements". 

    Does anyone know what this means and how I can fix it?

    tks!

     

  • August 18, 2005 at 4:55 am

    #582959

    How are you creating your ODBC data source. I believe it works ok with DirectAccess.

    --

    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

  • August 18, 2005 at 5:16 pm

    #583370

    through the ODBC Data Source Administrator.

    I don't know what DirectAccess is?

     

  • August 19, 2005 at 5:27 am

    #583470

    what is the name of the ODBC driver you are using?

    --

    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

     

  • August 21, 2005 at 7:59 pm

    #583791

    IBM DB2 ODBC DRIVER

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply