I need to connect to an oracle database running version 8 with a SQL 2000 Enterprise database. I need to download over 200 tables into the SQL database using DTS and the schedule agent.
I've installed the oracle 8 client ODBC drivers onto my sql box, created the dts package and it works perfectly. However, when I schedule the package I receive the following error.
Executed as user: WILDWEST\sqlservice. ...t: Create Table [GeneralConstruction].[dbo
].[tblWRHS
_UPDATE] Step DTSRun OnError: Create Table [GeneralConstruction].[dbo
].[tblWRHS
_UPDATE] Step, Error = -2147467259 (80004005) Error string: Cannot open database requested in login 'GeneralConstruction'. Login fails. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 4060 (FDC) Error string: Cannot open database requested in login 'GeneralConstruction'. Login fails. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: Create Table [GeneralConstruction].[dbo
].[tblWRHS
_UPDATE] Step DTSRun OnStart: Copy Data from WRHS_UPDATE to [GeneralConstruction].[dbo
].[tblWRHS
_UPDATE] Step DTSRun OnError: Copy Data from WRHS_UPDATE to [GeneralConstruction].[dbo
].[tblWRHS
... Process Exit Code 7. The step failed.
I also have the service that SQL & agent running on is a domain admin account as well.
Not understanding how this is happening, I completely uninstalled the oracle drivers (registry and all) from the machine and installed the 7.3 version of oracle ODBC drivers. Ran through the same process and it works under the scheduled package.
So my question is why can't I use the version 8 drivers?
Start Free Trial
