May 29, 2008 at 9:29 pm
➡ Hi. Hoping someone here can help me out.
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 I got it from before or if it is still available.
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.
May 29, 2008 at 9:53 pm
You need to install SQL Net (an Oracle product) onto your SQL box. Once done you need to configure it (you may simply be able to copy files such as TNSNAMES.ORA from an existing installation). Once done, the provider should be available to use in the linked server definition.
May 30, 2008 at 3:43 am
Thanks!
I will run the client installation and install only the component piece you have referenced.
I thought a full client installation was required and didn't want to do this for a single component piece, but based on the information you've provided this isn't the case.
I really appreciate your assistance and reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply