Re: PLEASE HELP! Call Failed errors after short inactivity with MS Access 2007 and MySQL(web host)

[Jay Alverson]

I used the dos prompt on my laptop to find the various timeout settings on
my server (same pc)...

c:\Program Files\MySQL\bin>mysqladmin -uroot -pmysql variables|find "timeout"
| connect_timeout                 | 10  |
| delayed_insert_timeout          | 300  |
| innodb_lock_wait_timeout        | 50  |
| innodb_rollback_on_timeout      | OFF  |
| interactive_timeout             | 28800  |
| net_read_timeout                | 30  |
| net_write_timeout               | 60  |
| slave_net_timeout               | 3600  |
| table_lock_wait_timeout         | 50  |
| wait_timeout                    | 28800  |


c:\Program Files\MySQL\bin>

There's also 2 TIMEOUT setting for the ODBC driver see:
http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-connection-parameters.html

>

Thanks, Jay



Edited 1 time(s). Last edit at 08/02/2009 09:55AM by Jay Alverson.