SQL (ODBC?) Timeout?

["Michael Naughton" <mnaughton@xxxxxxxxxxxx>]

Another developer here has an application in Notes/Domino that loads
records into a file on our AS/400. He says he's not using any fancy Domino
features -- he just sets up an ODBC connection using the Client Access
driver and does SQL inserts. His routine inserts about 1 record per
second, he says, and after about 600 records it seems to time out -- he
doesn't get an error message, or anything, but the inserts just stop. If
he starts is up again where it left off, it will keep going fine for
another 600 or so records, so it doesn't look like a data problem.

We're suspecting some sort of time out problem, but we're not sure where
to look. We're also wondering why a time out would happen anyway, since
there's constant traffic across the connection. I'm a real novice at this
side of things -- does anyone have an idea about what might be happening
and/or where we could look to find out more?

Thanks very much!

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx