AskSQLTeam
Ask SQLTeam Question
USA
0 Posts |
Posted - 07/15/2002 : 08:22:22
|
Montesh writes "Situation: Link Oracle Database to SQL Server 2000
I have been succesful to link Oracle Server to SQL Server 2000 "using the Microsoft Ole DB provider for Oracle" now i am unable to fire the following "Select OLinkServer.OraDatabase.User.TABLE " from the query analyser of the SQL SErver where the OradDatabase is linked to
please let me know all the possible ways to overcome the problems
I have already checked for the case sesitivity, the login issue , the registry settings given on the Microsoft Site but all in vain.
If there could something i have missed possibly let me know" |
|
robvolk
Most Valuable Yak
USA
15732 Posts |
Posted - 07/15/2002 : 09:05:50
|
I've found that when creating a linked server to Oracle sources, I need to include a full OLE DB provider string for both the product name and provider string settings:
sp_addlinkedserver @server = 'LinkedServerName', @srvproduct = 'Provider=MSDORA;Data Source=OracleServerName;User ID=username;Password=password;Initial Catalog=OracleDBName', @provider = 'MSDORA', @datasrc = 'OracleServerName', @provstr = 'Provider=MSDORA;Data Source=OracleServerName;User ID=username;Password=password;Initial Catalog=OracleDBName', @catalog = 'OracleDBName'
I know it's redundant to have to do all that, but it was the only way for me to get it to connect properly.
|
 |
|