How do I set up ODBC for replication from SQL Server to Oracle? : LUSENET : SQL Server Database Administration : One Thread

I've created a push subscription from SQL Server to be push to an Oracle Database. I'm having trouble with the ODBC setup. I've installed the Microsoft Oracle Driver and it is not connecting. Does SQLNET or NET8 need to be installed on the SQL Server machine for the ODBC connection to work? How does this work?

-- Anonymous, December 08, 1999



In 6.5 you need to create an extended stored procedure (see the xp_odbc example in the ODS samples) or an ODS gateway.

In 7.0 though, you can use a Linked Server to fire off your queries directly against Oracle using the Oracle OLE DB Provider, or any other data source that has an OLE DB Provider.

Good Luck,


-- Anonymous, December 12, 1999

yes you have to install net8 or the oracle client on that machine and you have configure the sqlnet, then only you can get the connection to your oracle database.

-- Anonymous, April 07, 2004

Moderation questions? read the FAQ