Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

draw Oracle data for SQL Server view

Status
Not open for further replies.

OhioSteve

MIS
Joined
Mar 12, 2002
Messages
1,352
Location
US
Our LAN has a server with an Oracle DB. I need data from that database, and I can ALREADY get that data through DTS. I use "Microsoft OLE DB Provider for Oracle" to run the packages. So I know that a connection IS possible.

Now I want to make a view that draws data from Oracle. How do I do that? There is no obvious way to make the connection.
 
You'll need to create a linked server from the SQL Server to the Oracle Server then you can access the Oracle database directly through T/SQL.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

[noevil]
(Not quite so old any more.)
 
Unfortunately that requires an ODBC connection. This database will not accept ODBC connections unless those connections are local. I can use the Microsoft OLE DB Provider for Oracle, but not ODBC.
 
You should be able to make a connection using the OLE-DB connection to the Oracle database for the linked server.

That same option should be availble in the new linked server option.

If it's not try using the sp_addlinkedserver system stored proc.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

[noevil]
(Not quite so old any more.)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top