Oracle Database Discussions

Hi, I've setup oracle client tools on a windows server that runs sql server 7
tnsping works as well as the client tool test feature on my sid.

However, I can't seem to use it from SQL Server. I've installed and uninstalled the client tools many times, I'm beginning to think perhaps I installed the wrong package. Weird thing is there is no Listener listed in Windows Services, yet the listener I setup is working.

I enabled the allow in process property of both the MSADAORA and Oracle OLE drivers from SQL Server, help!!

SELECT * FROM OPENQUERY(ORACLE_MIRROR, 'select count(1) from dual')

RESULTS IN:

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. 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' IDBInitialize::Initialize returned 0x80004005: ].

THIS IS AFTER I HAVE INSTALLED THE ORACLE 10.2 CLIENT TOOLS AND SETUP A LISTENER AND TESTED SIDS OK.

UTILIZING THE ORACLE OLE DRIVER IN THE LINKED SERVER I GET THIS ERROR:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'OraOLEDB.Oracle' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the e