Initialize data source ..?

[kenjoswe]

Hi all,

I have a Job in SQL-7.0 that triggers a stored procedure that supposed to retrive records from linked Oracle server. This has worked fine until now. When I check the error it says:
=================================================
Could not initialize data source object of OLE DB provider 'MSDAORA'.
[SQLSTATE 42000] (Error 7303) [SQLSTATE 01000] (Error 7312).
The step failed.
==================================================
I can run the above stored procedure manually from the Query Analyzer without problem.

Other Jobs with stored procedure that is not liked to the Oracle server starts fine.

Why can't I not 'initialize data source' from the Job any longer?

/Kent J.

 

[tlbroadbent]

Error 7303 generally refers to a logon authorization error. Are the logon and password used to execute the job valid on the Oracle Server? Typically, jobs run under the security of the SQLAgent account. Does the SQLAgent accont have access and appropriate permissions on the Oracle Server?

The following article refers to DTS jobs but may help you pinpoint the problem.

INF: How to Run a DTS Package as a Scheduled Job

http://support.microsoft.com/support/kb/articles/q269/0/74.asp

Terry

X-) "Life would be easier if I had the source code." -Anonymous