Hey all,
I've written an app that uploads a bunch of data to an Informix db via ODBC. It works great, albeit slowly as there are thousands of files and each file has hundreds of records to upload.
Mostly it works great and I can leave it running unattended for hours, but periodically the ODBC connection seems to get lost, leaving a dialog on the screen asking me to confirm the ODBC settings. Hitting [Enter] make it continue along happily.
I've checked "sleep" settings, set the network card to "never power down," checked the router's error logs for any glitches, but can't find a smoking gun why this happens. Any help thinking this through would be appreciated. I'm not even sure how to trap for the error when I'm issuing the SQLExec(), because it's not like it comes back with an Error - it just throws up that dialog.
Now that I'm talking this through - I wonder if putting it in "Server Mode" (sys(2335)) when I'm running the SQLExec() *would* cause it to throw an error instead - one that I can RETRY. I'll get back to you....
Eric
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---