Error upon executing script

  • Thread starter Thread starter Manymoe
  • Start date Start date
M

Manymoe

When I execute a script to scrape data from our mainframe, I receive
an error that system resources have been exceeded. The line taht
causes the error is as follows:

set rst1 = db.openrecordset("SELECT Year, Month, ERNO, EMP_NAME " _
& "FROM tblcollectionsnapshot_local " _
& "WHERE tblcollectionsnapshot_local.Year=" & varYear &
" AND tblcollectionsnapshot_local.Month=" & varMonth & " AND INS_FLAG
IS NULL AND FINS_FLAG IS NOT NULL AND ERNO NOT IN (" & strERNOHolder &
");",2)


We have not been able to figure out why out script will not run on one
machine but not another and the machines are similar in specs and
configuration.

Any asuggestions?
 
Back
Top