ODBC timeout after 30 seconssgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
sql server 7 has a database that is accessed through web page. When the clients try to down load larger files they gt an error "Microsoft Sql Server ODBC timeout" This happens after 30 seconds. How can I increase this interval so that the time out does not happen. There is no problem in down loading small data.
-- Anonymous, April 23, 2002
You can set the connection and statement timeout properties (ConnectionTimeout and CommandTimeout) on an ODBC connection and a statement timeout property on a statement. These values are in seconds. If you use 0, there will be no timeout.
Hope this helps,
-- Anonymous, April 25, 2002