February 28, 2006 at 11:18 am
I have a requirement on our Clustered SQL Server to be able to select data from an Oracle 9i database. SQL2000 SP3 on Win2003 SP1.
This is what i have done:
Installed Oracle 9i client sqlplus client on both clustered servers and configured the tnsnames file for that specific db. I can access the database on the server via SQL Plus. Then, I ran the below statements:
sp_addlinkedserver 'AIXORASVR','Oracle','MSDAORA','FILPQA.GLOBAL.ABC.COM'
sp_addlinkedsrvlogin 'AIXORASVR',false, NULL ,'LOGIN,'PASSWORD'
I get the below message when I attempt to use QA to select from the Oracle table:
select count(1) from AIXORASVR..schemaowner.binchartitem
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle client and networking components were not found.
I guess I don't understand what it wants me to install as I have installed the Oracle connectivity tool. Any ideas ?
March 1, 2006 at 10:02 am
I had to add something into tnsnames file on SQL Server machine. Ask your Oracle administrator
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply