I make two connections to an AS400 database.

esglobal.as400_connection = SQLSTRINGCONNECT(esglobal.lcConnectionString('GVsvr15', 'amflib6', 'draw', 'weber'))

esglobal.as400_connection2 = SQLSTRINGCONNECT(esglobal.lcConnectionString('GVsvr15', 'webprddt6', 'drawchg', 'webabc1'))

For some reason on some machines the second connection will give a Fatal Error but not all machines.

I tried this after all else has failed:
I try to start my exe on one of these machines and it fails. I delete the FOXUSER.FPT and FOXUSER.DBF files on that machine. I try and run it again and get the crash again. Then I run it the third time and it informs me the Resource file is not valid, I click YES and the exe starts ok. If I try it a fourth time it fails and continues to do so until I go through the delete file process.

This is so strange. Can someone help. This is a Timekeeping App and the users need to fill out their timesheets to get paid.