Oracle provider for OLEDB not found in SQL Server 2012

Question

I have installed Oracle 10g Database in Windows 2012 Server R2 but still Oracle provider for OLEDB not found in SQL Server 2012 (OraOLEDB.Oracle)

Please help how to add OraOLEDB.Oracle in SQL Server 2012 for creating Linked Server with Oracle 10g

Answer 1

If you have installed Oracle 10g but the OLEDB provider is still not available, you might need to install Oracle Data Access Components (ODAC). Download the appropriate version from the Oracle website and install it.

Then you need to register the OraOLEDB.Oracle Provider:

• Open a command prompt as an administrator.
• Navigate to the Oracle's bin directory where OraOLEDB10.dll resides.
• Run the command: regsvr32 OraOLEDB10.dll

And then configure the OLEDB Provider in SQL Server:

• Open SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
• Expand the "Server Objects" folder and right-click on "Linked Servers," then choose "New Linked Server."
• On the "General" page, choose the "Other data source" option.
• In the "Provider" dropdown, select "Oracle Provider for OLE DB" (if you don't see it, make sure the Oracle OLE DB provider is installed and registered).
• Enter the Product Name as "Oracle."
• In the Data Source box, enter the Oracle server's TNS name.
• On the "Security" page, enter the credentials used to connect to the Oracle server.

You may also need to provide the necessary permissions to the SQL Server service account to access Oracle.

It might be necessary to restart the SQL Server service and possibly the Oracle service for the changes to take effect.

• In SQL Server Management Studio, expand "Server Objects," then "Linked Servers."
• Right-click on the linked server you just created and choose "Test Connection."

If you continue to encounter issues, make sure:

• Oracle Client and ODAC are compatible with Oracle 10g and your Windows version.
• There are no firewall or network issues preventing the connection.
• The bitness (32-bit or 64-bit) of the Oracle client matches that of SQL Server.

Answer 2

Hi @Faizan Ahmed,

Here is a detailed blog mentioned about how to create a linked server with Oracle in SQL Server.

You may take a carefully reference to see if you missed any steps.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

Hi @Faizan Ahmed

Check this link from Microsoft Learn Set up and troubleshoot a linked server to an Oracle database in SQL Server

Regards

Javier