Replication to Oracle

  • I am trying to replicate to an Oracle server.

    I have already successfully replicated to the same Oracle server from another SQL Server.

    The SQL Server I am trying to replicate from is currently replicating to another SQL Server.

    I can connect to the Oracle server using SSIS on the same SQL server.

    However, every time I try to replicate I get a

    The process could not connect to Subscriber 'DSSLIVE' error, DSSLIVE being the oracle server.

    When I check the Replication monitor, the only detail I get is

    The process could not connect to Subscriber 'DSSLIVE'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20084)

    Get help: http://help/MSSQL_REPL20084

    Any ideas?

  • I know this won't help a lot but at least you know that you are not alone:

    http://www.sqlservercentral.com/Forums/Topic429499-291-1.aspx


    * Noel

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

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