Hi there,

I got this one problem which i encounter when i need to pull out data from database (SQLSERVER 2000).From the database i manage to query out data which take about 1 minutes but when i pull out data thru ASP connected to database, the error keep coming out.
Question: How to make the 'timeout expires' time longer than the current one from ASP?
Thanx

If you are having a script timeout, in your ASP code add this line:

Server.ScriptTimeout = 10000000

If it is a SQL timeout follow these instructions from BOL:

How to set a time limit for remote queries (Enterprise Manager)
To set a time limit for remote queries

Expand a server group.


Right-click a server, and then click Properties.


Click the Connections tab.


Under Remote server connections, in the Query time-out (sec, 0 = unlimited) box, type or select a value from 0 through 2147483647 to set the maximum number seconds that Microsoft® SQL Server™ will wait before timing out.


Note Remote server connections must be allowed before this value can be set.