SQL Server Performance Forum – Threads Archive

Problems connecting to Oracle from SQL Server

I am trying to do a remote query to a oracle machine from my local sql server. The query is as following.
select * from
OPENROWSET(‘MSDAORA.1′,’test’;’userid’;’password’,
‘select * from users’) When I run it from queryanalyzer i get the following message.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider ‘MSDAORA.1’ reported an error.
[OLE/DB provider returned message: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.]
OLE DB error trace [OLE/DB Provider ‘MSDAORA.1’ IDBInitialize::Initialize returned 0x80004005: ].
I have oracle client installed on my machine and I can connect to the oracle db using dts,visual basic and sql plus.can somebody please tell me what the problem is and how can I make it work.
TIA

---

Check: http://www.code101.com/Code101/DisplayArticle.aspx?cid=35 HTH Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

---

Thanks,
A reboot solved the problem.

---

]]>