August 11, 2009 at 4:43 am
I have scheduled a job which runs a stored procedure every 30 minutes. In the stored procedure it connects to Oracle Linked server and pulls some data and updates in SQL tables. If I am running this SP, in query window, it never fails. But thru SQL jobs, many times it is running perfectly but sometimes it is giving following error:
Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "". [SQLSTATE 42000] (Error 7303) OLE DB provider "MSDAORA" for linked server "" returned message "Oracle error occurred, but error message could not be retrieved from Oracle.". [SQLSTATE 01000] (Error 7412). The step failed.
Has anybody faced & resolve this issue...
August 11, 2009 at 6:05 am
Duplicate post.
Add your replies to this thread:
http://www.sqlservercentral.com/Forums/Topic768480-146-1.aspx
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply