Home > IT Answers > SQL Server > Error accessing Oracle data using SQL job
Randym
1,740 pts.
 Error accessing Oracle data using SQL job
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.

Software/Hardware used:
ASKED: August 6, 2008  4:11 PM
UPDATED: September 9, 2008  9:40 AM
RELATED QUESTIONS
Answer Wiki:
Sounds like someone has uninstalled the Oracle drivers from the SQL Server. Try reinstalling the Oracle drivers on the SQL Server.
Last Wiki Answer Submitted:  September 9, 2008  9:40 am  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,505 pts.