how do you connect to AS400 "directly using DSN through ADO

• Nelson Viggiani-332216

  Ten Centuries

  Points: 1264

  More actions

  December 15, 2006 at 6:42 am

  #114884

  I need to connect to AS400 to transfer data from SQL Server 2005 to AS400

  I created a linked server and I'm getting error's

  this is the command line ==

  delete openquery(LPUSA01_A, 'select * from BZRCRP')

  and this is the error:

  OLE DB provider "MSDASQL" for linked server "LPUSA01_A" returned message "[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - BZRCRP in EBSTSTNEW not valid for operation.".

  what i'm doing wrong???

  thanks

   

   

   

• webooth

  SSCommitted

  Points: 1520

  More actions

  December 18, 2006 at 7:41 am

  #678650

  Is Journalling turned on for the object you want to delete from on the AS/400?