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
Loading
Mohammad HussainPosted Aug 15, 2023, 12:21 PM
Hi Faizan,
Please check the below link, it may help you. Thanks...
You should check compatibility first mode:
https://docs.oracle.com/cd/E11882_01/server.112/e23633/intro.htm#CEGJDHGI
Adding a Linked Server with “Oracle Provider for OLE DB”:
https://sqlsailor.com/2013/03/13/linkedsrvoracleprov/