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, 2024 at 18:48
David Browne - Microsoft
49.2k3 gold badges53 silver badges102 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/…Balazs Kiss– Balazs Kiss2024-05-26 00:53:19 +00:00Commented May 26, 2024 at 0:53
-
Thanks. I updated the link.David Browne - Microsoft– David Browne - Microsoft2024-05-26 16:52:25 +00:00Commented May 26, 2024 at 16:52