[PHP-DB] ODBC Timout for MS SQL Driver

2003-03-03 Thread Ryan Jameson (USA)
Does anyone know a reliable way to set an ODBC connection to timeout after a very 
short time? I've tried set_time_limit but when the query is running PHP does not drop 
out, I've also tried odbc_setoption on the connection before executing. Basically, I 
want it to just fail quicker if it is going to. 30 seconds is too long.

 Ryan

Ryan Jameson
Software Development Services Manager 
International Bible Society
W (719) 867-2692

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] ODBC Timout for MS SQL Driver

2003-03-03 Thread Ryan Jameson (USA)
Ok I tried this another way but using the ms sql functions along with:

ini_set(mssql.timeout,2);
ini_set(mssql.connect_timeout,2);

... no change, it still takes about 7-8 seconds to decide it couldn't connect.

 Ryan

-Original Message-
From: Ryan Jameson (USA) 
Sent: Monday, March 03, 2003 11:01 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] ODBC Timout for MS SQL Driver


Does anyone know a reliable way to set an ODBC connection to timeout after a very 
short time? I've tried set_time_limit but when the query is running PHP does not drop 
out, I've also tried odbc_setoption on the connection before executing. Basically, I 
want it to just fail quicker if it is going to. 30 seconds is too long.

 Ryan

Ryan Jameson
Software Development Services Manager 
International Bible Society
W (719) 867-2692

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php