April 11, 2006 at 1:55 pm
I am replicating data on a HP 64 bit SQL server machine. I pull data from Oracle for reporting. The DTS runs without and issue. I am using the Oracle 8i interface to get the correct odbc.
Currently the jobs are running under network\Admisinistrator. I can log into the machine and launch the dts as administrator just fine but when I schedule it as a job I get the following
[Microsoft][ODBC driver for Oracle][Oracle]ORA-06413: Connection not open
I looked up the issue but I have no way of knowing where the job is hitting the odbc and where the issue would be.
Any help is appreciated
April 14, 2006 at 8:00 am
This was removed by the editor as SPAM
September 2, 2006 at 12:58 pm
I have had the same problem and solved it by useing the runas command in the scheduler.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply