By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,866 Members | 2,039 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,866 IT Pros & Developers. It's quick & easy.

ADODB slow response over the network

P: 1
We are classic ASP programmer. We are using the database sql server 2005 management studio. ASP page is on one machine (Window server 2012 R2) and sql server 2005 management studio is on another machine (Window server 2003). When run the ASP page, It gives very slow response.
Script look like this.

strsql="select * from test1" '' 25 records on this table
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open strsql, objCnn

if not rs.eof then
while not rs.eof
id = rs("id")
qty="select count(*) as tcount from test2 where id=" & id
Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.open qty, objCnn
if not rs1.eof then
tcount = rs1("tcount")
end if
rs1.close
set rs1=nothing
rs.movenext
wend
end if
rs.Close : Set rs = Nothing

when both database and ASP script on same machine then it does not take time to response. It gives response in 1-2 second but when both is in different machine it takes long time then gives the response. Some times it gives ScriptTimeout error.
We have opened the both database on the same machine and run the same query it does not take time. Query exucute time is Approx.equal.

Is there missing any IIS or ADO setting?

Can you please help us?
Nov 4 '16 #1
Share this Question
Share on Google+
2 Replies


P: 8
i am also having the same problem's
Jul 20 '17 #2

P: 8
Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
Jul 20 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.