Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Replication between SQL 2005 and DB2

    Problem resolved.

    Solution: Activate journaling on the tables and use of the microsoft ole db provider for odbc

  • RE: Replication between SQL 2005 and DB2

    Hi again 🙂

    I think I'm just in the last step for do the replication, now I get this error:

    "The job failed. The job was invoked by user . THe last...

  • RE: Replication between SQL 2005 and DB2

    Good news everyone, I can do querys to the tables in the AS400 with the SQL Server Managament Studio, then my provider string is good and I have a link...

  • RE: Replication between SQL 2005 and DB2

    The problem still persist.

    I generate the following provider string:

    Provider=DB2OLEDB;User ID=****;Password=****;Initial Catalog=PALAMOS;Network Transport Library=TCP;Host CCSID=1252;PC Code Page=1252;Network Address=SERVERADRESS;Network Port=446;Package Collection=RESTAURA;Default Schema=RESTAURA;Process Binary as Character=False;Units of Work=RUW;Default Qualifier=RESTAURA;DBMS Platform=DB2/AS400;Defer Prepare=False;Persist Security Info=True;Connection...

  • RE: Replication between SQL 2005 and DB2

    Prakash.Bhojegowda (3/18/2011)


    Not sure if your environment is same as ours.

    We have 32 bit operating system + 32 bit SQL Server Enterprise Edition server.

    Are you using the conenction string created using...

  • RE: Replication between SQL 2005 and DB2

    I got the same error and can't find info about that on Internet.

    How I can solve this problem?

Viewing 6 posts - 1 through 6 (of 6 total)