ASP + SQL : Why does Connectiontimeout has no effect?

[Dollie]

We have some queries that are taking a long time to return.
IIS is retuning a timeout error, as the MS-SQL 2000 box has not returned with results in the expected time.

We set connectiontimeout = 0 or connectiontimeout = 9999
makes no difference.

anyone know how to make IIS wait for SQL?

Stephen.

 

[Bastien]

server.settimeout = n 'seconds

Bastien

Cat, the other other white meat

 

[Tarwn]

The default timeout is 90 seconds (1.5 minutes). It seems odd to me that the database is taking longer than that to return records (though I have seen it happen). You may want to look into making your SQL calls more efficient or better yet creating stored procedures (if your database supports it).

You may also want to try placing some Response.Flush's before and after your call to the database to make sure the slowdown is occurring during communications with the DB and not in your processing of the recordset in ASP.

-T

[sub]01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111[/sub]
Need an expensive ASP developer in the North Carolina area? Feel free to let me know.