Error accessing Oracle data using SQL job

1740 pts.
Tags:
DTS Package Scheduled Task
OLE DB
Oracle 7
SQL Server 2000
I have a DTS package that use the MS OLE DB provider for Oracle. The DTS package executes stand alone; but when placed in a schedule job, it won't run. This was working; but quit after I had detached some databases to copy them. After re-attaching them, the jobs would no longer run. I have logged into the Enterprise Manager with the same credentials as what the SQL Server agent uses and that user can execute the DTS package successfully. But the job will not run it. The message I get is: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Again this only happens when the job tries to execute the DTS package.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Sounds like someone has uninstalled the Oracle drivers from the SQL Server. Try reinstalling the Oracle drivers on the SQL Server.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following