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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database link to Oracle

Status
Not open for further replies.

TWillard

Programmer
Joined
Apr 26, 2001
Messages
263
Location
US
Hello all. I am running a web app using sql server as my background database. The project has grown and I need employee information from an Oracle database. I am fairly fluent with sql statements on both the oracle and sql server environments. I experience with with database linking in Oracle, but none for sql server. Could someone please tell me how I can link sql server to oracle.

I would like to build it such that I have a stored procedure in sql server that performs a direct select statement against a table in an oracle database. I have an ODBC connection on my sql server computer that can access the oracle database. In fact I have used the import/export data wizard to copy over database tables from oracle.

Any help would be much appreciated.

 
Look up sp_addlinkedserver in books online. Pretty easy to set up.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top