Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server

Problem: I receive this error.
Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "xxxx.WORLD".


Solution
Go to the the OraOLEDB.Oracle provider options and tick "Allow inprocess"


No comments:

Post a Comment