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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Read from Oracle with a SQL Stored Proc 1
- Thread starter alexm
- Start date
-
1
- #2
alexm,
What you are looking to do is create a linked server. Using ODBC you can create a linked server using the sp_addlinkedserver stored procedure. You then create a login for the server using the sp_addlinkedsrvlogin.
The last set is to create a view based on the linked server. For more information you can check out "Creating Heterogenous Query with Microsoft SQL Server 7.0" in the MS Knowledge Base. This document will give you step by step instructions for working with Ocacle data from within SQL Sever.
Good Luck
Joe Kurtz [sig][/sig]
What you are looking to do is create a linked server. Using ODBC you can create a linked server using the sp_addlinkedserver stored procedure. You then create a login for the server using the sp_addlinkedsrvlogin.
The last set is to create a view based on the linked server. For more information you can check out "Creating Heterogenous Query with Microsoft SQL Server 7.0" in the MS Knowledge Base. This document will give you step by step instructions for working with Ocacle data from within SQL Sever.
Good Luck
Joe Kurtz [sig][/sig]
- Thread starter
- #3
- Status
Similar threads
- Question
