Unanswered: Instance of OLE DB provider can not be created
Hello. I get the following error message from Server-Agent-Jobs:
Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "xxx". [SQLSTATE 42000] (Error 7302).
The linked server already exists a long time and has always worked. I can still see all the tables and can query the data via select. The stored procedure that is called in the job, can I call manually. Only by job, it will go wrong.
Does anyone know what can I do? Thanks for the help.