ODBC Time out Expired

<i><b>Originally posted by : V.Karthik Vaidyanathan (karthikvv@india.com)</b></i><br /><br />Hi ,<br /><br />I am experiencing a MS-SQL Server ODBC Time out expired problem, while running a query which runs for more than a minute. the query has only one output and is working fine when tried with Query Analyser. I would like to know, how i could rectify or solve this problem. Thanking You in advance.

<i><b>Originally posted by : Mark Eastham (mark.eastham@masoncom.com)</b></i><br /><br /><br />in ASP, when u type an object name followed by '.' (full stop) it show u a list of available methods....<br /><br />check out 'connectiontimeout' and 'commandtimeout' or 'querytimeout'<br /><br />I may not exactly have the spelling correct but u'll get the picture.....<br /><br />if u set them to '0' they are forever!!<br /><br />------------<br />V.Karthik Vaidyanathan at 9/2/2000 3:12:40 AM<br /><br /><br />Hi ,<br /><br />I am experiencing a MS-SQL Server ODBC Time out expired problem, while running a query which runs for more than a minute. the query has only one output and is working fine when tried with Query Analyser. I would like to know, how i could rectify or solve this problem. Thanking You in advance.