ODBC timeout after 30 seconss

greenspun.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

Answers

Baldev,

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,

Eric

-- Anonymous, April 25, 2002


Moderation questions? read the FAQ