PJ_SQL
SSCertifiable
Points: 6703
More actions
March 29, 2016 at 1:26 pm
#325262
What are the options for cross data between Oracle and SQL besides ODBC?
Eric M Russell
SSC Guru
Points: 125561
March 29, 2016 at 1:29 pm
#1868380
ODBC is just the provider library. OLEDB is another option, but I guess you're really asking about how to setup a linked server, for querying Oracle within SQL Server.
To create a linked server to access an Oracle database instance
https://technet.microsoft.com/en-us/library/ms190618(v=sql.105).aspx
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 29, 2016 at 3:54 pm
#1868432
How do we do using OLEDB?
For Linked Server, do we need to install Oracle client in the server which is running SQL?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply