Oracle to SQL Server

• JKSQL

  SSCrazy Eights

  Points: 8481

  More actions

  April 11, 2006 at 1:55 pm

  #112489

  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

   

• MandM

  Grasshopper

  Points: 18

  More actions

  September 2, 2006 at 12:58 pm

  #658180

  I have had the same problem and solved it by useing the runas command in the scheduler.