Tag: Oracle Linked Server

Error - Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server. (.Net SqlClient Data Provider)

Error/Fix: Cannot initialize the data source object of OLE DB provider “OraOLEDB.Oracle” for linked server. (.Net SqlClient Data Provider)

Ajay Dwivedi | February 20, 2020

Recently I was working on one user request to create a linked server for Oracle database in SQL Server 2014 instance. After installing the correct Oracle ODBC drivers,