sql server odbc: Accessing Oracle from within SQL Server -- sql server odbc

Accessing Oracle from within SQL Server

Paul Anderson
6/28/2006 12:00:00 AM

sql server odbc: Using Oracle's Heterogeneous Services, it's possible to gain access to
SQL Server tables via ODBC.

Is the reverse possible? Does SQL Server have the ability to read/write
from/to an Oracle table using ODBC? Is there anything to install? Or
is this functionality that comes with SQL Server?

Thank you.

Re: Accessing Oracle from within SQL Server

Sue Hoegemeier
7/2/2006 5:08:29 PM

Yes it's possible. You need to install and configure the
Oracle client on the SQL Server box.
You can find additional information in SQL Server books
online under topics such as Linked Servers and Distributed
Queries. The following article also has some information on
this:
How to set up and troubleshoot a linked server to an Oracle
database in SQL Server
http://support.microsoft.com/?id=280106

-Sue

On Wed, 28 Jun 2006 08:25:00 -0400, Paul Anderson
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.