March 10, 2012 at 1:38 pm
Hi friends,
I'm trying to create linked server from SQL Server 2005 SP3 on Windows 2003 64-bit to Oracle database 64-bit.
Steps are below:
Installed InstantClient Oracle 11gR2 (11.2.0.1.0) for Microsoft Windows (x64) to C:\Oracle\product\11.2.0\client_1 folder on the SQL Server - database server.
Installed ODAC (11.2.0.2.1) ODAC112021Xcopy_x64 for Windows x64 by executing
install.bat all C:\Oracle\product\11.2.0\client_1 odac
Checked the Allow inprocess of OraOLEDB.Oracle provider in SSMS.
Created ODBC connection to the Oracle database - ORADB. Connection successful via ODBC and sqlplus.
Executed sp_addlinkedserver @server = 'TEST_LINK', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasrc = 'ORADB'
I have executed sp_addlinkedsrvlogin @rmtsrvname = 'TEST_LINK', @useself = 'FALSE', @rmtuser = 'orauser', @rmtpassword = 'pwd'
The orauser is the oracle username and pwd is the password for the oracle user orauser.
When I click Test Connection for the linked server TEST_LINK in SSMS, it just hangs.. When I try to run a query
to ORADB , 'select * from TEST_LINK..ORAUSER.TABLE1 ' - it runs forever and eventually SSMS hangs.
Please help.. Thanks
March 12, 2012 at 5:19 am
Your way is much clearer than mine using the full oracleinstall.
July 1, 2015 at 7:44 am
Were you able to resolve this issue? I am facing the same problem with sql server 2012.
Cheryl
July 1, 2015 at 7:50 am
Yes.. it was some network related problem. After reboot of the server, it worked
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy