Linked Server Setup Error

I'm trying to link my local SQL 2005 with a remote oracle database. I have downloaded the oracle 10g client. It seems the client installed a data source driver for me to use (Oracle in OraDb10g_home2). I created a new data source named 'Company' which I have successfully connecting using that driver.

The following is the script I'm using to create my linked server:


USE master

GO

sp_addlinkedserver

@server = 'Company',

@provider = 'OraOLEDB.Oracle',

@srvproduct = 'oracle',

@datasrc = 'Company'

GO

sp_addlinkedsrvlogin

@rmtsrvname = 'Company',

@useself = 'false',

@rmtuser = 'Company1',

@rmtpassword = 'MyPassword'

These both execute successfully.

Then when I go to make a select call:

SELECT * FROM OPENQUERY(Company, 'SELECT * FROM CAMPUS')

I get the following error:

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "OraOLEDB.Oracle" for linked server "Company" reported an error. The provider did not give any information about the error.

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "Company".

I think my proplem may be that this provider does not match with my data source.... Any ideas?