You have to set up an ODBC (System DSN) connection first on the SQL Server
to the Oracle Server. Then you create a linked Server that will use that
ODBC connection. Then you can create your publisher that allows SQL Server
2000 or Heterogeneous Data Sources, and then create a push subscription on
the SQL Server to the Oracle server.

-Stephen

-----Original Message-----
From: Thiagarajan Gopalakrishnan
[mailto:Thiagarajan.[Email Address Removed] Tuesday, November 26, 2002 12:19 AM
To: LazyDBA.com Discussion
Subject: Oracle Subscription to a SQL Server Publication


> Hi
>
> Could anyone help me to replicate between SQL Server and Oracle.
>
> The scenario is the Publishser is SQL Server and the Subscriber
Oracle.
>
> The earlier you replies the better.
>
> Thanks & Regards
> PG Thiagarajan
>

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page