Hi! I'm using Visual Foxpro 6.0 for develop my application whitch is connected to MySQL 4.1 via MyODBC (3.2.51) driver. I'm using several methods in my program to monitor server state and switch from one server to another if server or connection failure occurs. There is one big problem about connection failures at the query executing time - query hangs (and program interface too) and I can't switch to offline mode (in my program).
Is it possible to set maximum query execution time per session/query like I can do this by connecting to database (in foxpro with SQLSETPROP("") function)? Or is it MyODBC driver-relalted issue? = SQLSETPROP(sqlh,"ConnectTimeOut",1) && works for me = SQLSETPROP(sqlh,"QueryTimeOut",10) && doesn't do that bregs Hendrik =============================================== tel: 046 31634 DC Doora AS gsm: 051 51789 Heltermaa mnt 6 fax: 046 31455 Kärdla, Hiiumaa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]