Hello all,

I make a connection with a mysql server and open some recordsets based on its database. Everything works fine excepts that sometimes I need to prompt the user for some input. If the user answers the question posed by my pop up box within a reasnable time frame (less then a minute) the transaction goes fine and the database updates properly.

The problem arises if the user goes away from the keyboard for lets say 5 minutes once the pop up box prompts them. Then once they return and enter the information asked of them they get a "lost connection to mysql server" message....It seems that I only have a brief period of time for my connection object to be open otherwise it drops.

Any one have any idea how to fix this?

I tried playing around with the
cn.ConnectionTimeout
and
cn.CommandTimeout

properties but without much luck...

thanks


Language used :VB6
Connection method:ADODB
Provider:ODBC
Remote Database: MySQL