SEO

#1 (**permalink**) 02-28-2008, 09:10 AM

I wrote a program in vb6 that connects to a db mysql 5. I installed the
program on clients in the local network and on clients that connects to db
by public ip by internet.
In local network it works perfectly but by internet it disconnect to db
after a timeout (maybe 60s) when the program doesn't communicate with db.
Is a server problem (win 2000 server) or a db problem? Can I increase the
timeout?

Thanks

bye,
max

#2 (**permalink**) 02-28-2008, 09:10 AM

On Wed, 14 Feb 2007 16:05:18 +0100, Massimo wrote:

> I wrote a program in vb6 that connects to a db mysql 5. I installed
> the program on clients in the local network and on clients that
> connects to db by public ip by internet. In local network it works
> perfectly but by internet it disconnect to db after a timeout (maybe
> 60s) when the program doesn't communicate with db. Is a server problem
> (win 2000 server) or a db problem? Can I increase the timeout?

Is this a problem in connecting, or a problem with an established
connection going away after a while? If the latter, perhaps the
application might be more robust to close connections after full
transactions and restablish when it's time to do more work.

--
36. I will not imprison members of the same party in the same cell block, let
alone the same cell. If they are important prisoners, I will keep the only
key to the cell door on my person instead of handing out copies to every
bottom-rung guard in the prison. --Peter Anspach's Evil Overlord List

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode