OraOLEDB.Oracle Provider Missing

[mindscape]

Hi.

I am trying to add a linked Oracle Server to our MSSQL 2005 server but am missing the OraOLEDB.Oracle Provider under Server Objects -> Linked Servers -> Providers in the Object Explorer.

Also I have considered using a simple OPENROWSET command to attach to the Oracle Instance but unfortunately one of the parameters required is the name of the Provider for the connection which puts me back at square one for resolution.

I seemed to have recalled some time back having downloaded the Oracle Driver for MSSQL but I can't for the life of me find the location that I acquired it from before.

Does anyone know where I can get the driver or where I can get explicit instructions for installing the driver on SQL Server??? I don't want to install the entire Oracle Client just to acquire the 1 driver I need to accomplish my task.

Any input or suggestions would be greatly appreciated.

[skhanal]

You can get it from technet.oracle.com