I am trying to configure a Linked Server in SQL Server to Oracle database. However, I am unable to find OraOLEDB.Oracle in the providers list of the linked servers.
Would you please guide me to find a solution to this issue ?
Thank you :)
Asked
Active
Viewed 632 times
0
-
what version of sql server, what version of Oracle? – kevinskio Mar 16 '15 at 14:02
-
@kevinsky SQL Server 2012, Oracle 11 g – Akram Shahda Mar 16 '15 at 14:03
1 Answers
0
You need to have the latest ODAC package from Oracle installed on the SQL Server end. This includes an OLEDB driver.
kevinskio
- 4,431
- 1
- 22
- 36