We are using VB6 to access the MYSQL, while we use ADO OCX to connect to the database, we are able control the timeout, but using connection string, we are unable to .
As our current applications perform minimum of one update/addnew per second and sometime, even more. There are at least 10 applications accessing the same table. At lately, we have experience a lot of incident whereby the connection are lost or timeout. My Question :- 1) How to control the time out using connection string ? 2) Under our working environments, Inno is ISAM is better 3) How to error trap the connection existence ? 4) Sometime, during update using the ADO OCX, we will get Multiple Step generate error Regards SB Lim --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php