I would like to connect from my SQL Server 2017 to an Oracle database via Linked server. I installed the Oracle driver from Oracle-Client-for-Microsoft-Tools-64-bit.exe, but the driver does not appear in the Provider list under Linked server. Rebooted the server, but still no help. What am I missing? I only installed the Oracle driver from the Oracle Client installer package as I thought I don't need the other parts.
1 Answer
Linked server uses OleDb, and the Oracle OleDb provider isn't in that package. It's only the ADO.NET driver and low-level Oracle client (OCI.dll), which is what's needed for most other Microsoft server tools.
To install the OleDb provider, use the ODAC XCopy package here.
answered May 25 at 18:48
David Browne - MicrosoftDavid Browne - Microsoft
47.6k3 gold badges51 silver badges101 bronze badges
-
Yes, indeed the OleDB Provider is needed from the ODAC package, correct, thank you. On the link above I only found the 12c version, I need 19c. I found it here: oracle.com/database/technologies/… Commented May 26 at 0:53
-