0

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.

asked May 25, 2024 at 14:52

1 Answer 1

1

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
2
  • 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, 2024 at 0:53
  • Thanks. I updated the link. Commented May 26, 2024 at 16:52

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.