p2p.wrox.com: Archives - asp

asp_databases thread: Script keeps timing out

Message #1 by dfalconer@g... on Mon, 17 Dec 2001 19:28:07

Hi,

 i am running an ASP script but it keeps timing out at the same point and 

i can't workout what time out property to change to make it work, i have 

tried server.scripttimeout and it doesnt make a difference (it times out 

at the same point). Can any one tell me where to find and change the 

property that is causing the timeout.



Microsoft OLE DB Provider for ODBC Drivers error '80040e31' 



[Microsoft][ODBC SQL Server Driver]Timeout expired 



/admin/stats/file_download_report.asp, line 12 



cheers

Message #2 by Kyle Burns <kburns@c...> on Mon, 17 Dec 2001 16:03:13 -0500

The TimeOut that is occuring has nothing to do with Server.ScriptTimeout.

You are experiencing an ODBC timeout while waiting for results from your SQL

Server.  You should take a look at the statement that is being executed to

cause the timeout and make corrections from there.  If this is a query

retrieving a large result set, then you may want to consider using a stored

procedure to enhance the performance of the query.  You should also take a

look at the indexing of your fields.







=================================

Kyle M. Burns, MCSD, MCT

ECommerce Technology Manager

Centra Credit Union

kburns@c...



 



>> -----Original Message-----

>> From: dfalconer@g... [mailto:dfalconer@g...]

>> Sent: Monday, December 17, 2001 2:28 PM

>> To: ASP Databases

>> Subject: [asp_databases] Script keeps timing out

>> 

>> 

>> Hi,

>>  i am running an ASP script but it keeps timing out at the 

>> same point and 

>> i can't workout what time out property to change to make it 

>> work, i have 

>> tried server.scripttimeout and it doesnt make a difference 

>> (it times out 

>> at the same point). Can any one tell me where to find and change the 

>> property that is causing the timeout.

>> 

>> Microsoft OLE DB Provider for ODBC Drivers error '80040e31' 

>> 

>> [Microsoft][ODBC SQL Server Driver]Timeout expired 

>> 

>> /admin/stats/file_download_report.asp, line 12 

>> 

>> cheers

>> 




>> $subst('Email.Unsub').

>>

Message #3 by dfalconer@g... on Tue, 18 Dec 2001 10:01:02

> The TimeOut that is occuring has nothing to do with Server.ScriptTimeout.





> You are experiencing an ODBC timeout while waiting for results from your 

SQL

> Server.  You should take a look at the statement that is being executed 

to

> cause the timeout and make corrections from there. 







 If this is a query

> retrieving a large result set, then you may want to consider using a 

stored

> procedure to enhance the performance of the query.  You should also take 

a

> look at the indexing of your fields.

> 

> 

> 

> =================================

> Kyle M. Burns, MCSD, MCT

> ECommerce Technology Manager

> Centra Credit Union

> kburns@c...



Thanks Kyle

there must be a place on the SQL server where i can up the timeout property

the script will only be run by myself very infrequently.

> 

>  

> 

> >> -----Original Message-----

> >> From: dfalconer@g... [mailto:dfalconer@g...]

> >> Sent: Monday, December 17, 2001 2:28 PM

> >> To: ASP Databases

> >> Subject: [asp_databases] Script keeps timing out

> >> 

> >> 

> >> Hi,

> >>  i am running an ASP script but it keeps timing out at the 

> >> same point and 

> >> i can't workout what time out property to change to make it 

> >> work, i have 

> >> tried server.scripttimeout and it doesnt make a difference 

> >> (it times out 

> >> at the same point). Can any one tell me where to find and change the 

> >> property that is causing the timeout.

> >> 

> >> Microsoft OLE DB Provider for ODBC Drivers error '80040e31' 

> >> 

> >> [Microsoft][ODBC SQL Server Driver]Timeout expired 

> >> 

> >> /admin/stats/file_download_report.asp, line 12 

> >> 

> >> cheers

> >> 




> >> $subst('Email.Unsub').

> >>

Message #4 by arshad siddiqui <ash_arshad@y...> on Tue, 18 Dec 2001 20:51:23 -0800 (PST)

Hi,

I am now using stored procedures as suggested by

you,but still the same problem is coming.



Microsoft OLE DB Provider for ODBC Drivers error

'80040e31' 

[Microsoft][ODBC SQL Server Driver]Timeout expired 



/1024x768/stocklevel.asp, line 53 



Please help

Regads

--Arshad--





__________________________________________________

Do You Yahoo!?

Check out Yahoo! Shopping and Yahoo! Auctions for all of

your unique holiday gifts! Buy at http://shopping.yahoo.com

or bid at http://auctions.yahoo.com

Message #5 by "Kim Iwan Hansen" <kimiwan@k...> on Wed, 19 Dec 2001 07:39:10 +0100

it usually helps if you check your error messages / descriptions on

support.microsoft.com.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q293318



-Kim





> -----Original Message-----

> From: arshad siddiqui [mailto:ash_arshad@y...]

> Sent: 19. december 2001 05:51

> To: ASP Databases

> Subject: [asp_databases] Script keeps timing out

>

>

> Hi,

> I am now using stored procedures as suggested by

> you,but still the same problem is coming.

>

> Microsoft OLE DB Provider for ODBC Drivers error

> '80040e31'

> [Microsoft][ODBC SQL Server Driver]Timeout expired

>

> /1024x768/stocklevel.asp, line 53

>

> Please help

> Regads

> --Arshad--

>

>

> __________________________________________________

> Do You Yahoo!?

> Check out Yahoo! Shopping and Yahoo! Auctions for all of

> your unique holiday gifts! Buy at http://shopping.yahoo.com

> or bid at http://auctions.yahoo.com

>




> $subst('Email.Unsub').

>

Message #6 by arshad siddiqui <ash_arshad@y...> on Sun, 23 Dec 2001 23:27:16 -0800 (PST)

Hi,

I used sql statemets then also script keps timing

out,then I used stored procedure after that also same

error is coming.I tried the microsoft

link(http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q293318)

also but there they are giving only the cure for sql

server 2000,but here I am using sql server 6.5

Here is the code I am using.

____________________________________________________

<%@ language="vbscript" %>

<%session.Timeout  =10%>

<%Response.Expires   =20%>

<%server.ScriptTimeout =1000%>

<%Response.CacheControl =true	%>

<%dim user

user=session("user")%>



<!-- #INCLUDE VIRTUAL FILE="adovbs.inc" -->

<%

flag1=false

flag2=false

If Session("UserLevel") <>2  Then

  Response.Redirect "..\default.asp" &

Request.ServerVariables("SCRIPT_NAME")

End If

%>

<%

Response.Write vals

DIM currentPage, rowCount, i, typ,root,star,lastv

'currentPage =Request("currentPage")

dim contarctstart,locationstart,date1

contractstart=request("contractno")

'storerstart=request("storerno")

date1=request("date1")

locationstart=request("location")

'if currentPage = "" then currentPage=1 

'if contractno="" then contractno=509 

dim cn

set cn=server.createobject("ADODB.Connection")

cn.open "DSN=mydsn1;UID=sa;PWD=sql;"



ssqlcontract="nspStockLevelBalanceContract '"&

contractstart &"','"& user &"','"& date1 &"'"

ssqlloc="nspStockLevelBalanceLocation '"&

locationstart &"','"& user &"','"& date1 &"'"

ssqlcontloc="nspStockLevelBalanceContLoc '"&

contractstart &"','"& user &"','"& locationstart

&"','"& date1 &"'"

ssqldate="nspStockLevelBalanceDate '"& user &"','"&

date1 &"'"

ssqlcarr="nspStockLevelBalanceContract '"& carr

&"','"& user &"','"& date1 &"'"



'set rss=cn.Execute (ssqlcontract)

%>

<html>



<head>

<meta http-equiv="Content-Language" content="en-us">

<meta http-equiv="Content-Type" content="text/html;

charset=windows-1252">

<meta name="GENERATOR" content="Microsoft FrontPage

4.0">

<meta name="ProgId"

content="FrontPage.Editor.Document">

<base target="_self">

<title>Stock Level Balance Report</title>

</head>

<body bgcolor="#b0b3b4" topmargin="0" leftmargin="0">

<table border="0" width="1006" style="height: 64px">

<%

if (contractstart="" and locationstart="" and

date1<>"") then %>

        <%  dim total1,total2,total3

        total1=0

        total2=0

        total3=0

        %>

        <%set rsstest=cn.Execute (ssqldate)%>

       <tr bgcolor ="white"><td colspan=7></td><td

colspan=2 align=center> <input type="image" 

valign="top" value="print" src="printer.gif"

Onclick="print()" ; id=image1 name=image1></td></tr>

<%      

do while not rsstest.eof 

	carr=rsstest(14) 

	%> 

<tr>

	<td colspan=6 bgcolor="white">

		<font color="#10337a"><b>Storer No.<%=user%></td><td

colspan=3 bgcolor="white" align=left><font

color="#10337a"><b> Contract

No.<%=carr%></b></td></font>

	</tr> 

<% set rsscarr=cn.Execute (ssqlcarr)

if rsscarr.eof then

%>

<tr><td colspan=9><font color=blue>No records

available</font></td></tr>

<%

else

dim summ1,summ2,summ3

summ1=0

summ2=0

summ3=0

%>

<tr>

          <td width="90" bgcolor="white"><font

size="1" face="Arial" color="#461d5c"><b>Cotton Lot

#.</b></font></td>

          <td width="80" bgcolor="white"><font

size="1" face="Arial" color="#461d5c"><b>Bales

Available.</b></font></td>

          <td width="87" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><b>UOM</b></font></td>

          <td width="105" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><b>GWT</b></font></td>

          <td width="106" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><b>NWT</b></font></td>

          <td width="95" bgcolor="white"><font

size="1" face="Arial" color="#461d5c"><b>Product

Group</b></font></td>

          <td width="92" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><b>Grade/Class</b></font></td>

          <td width="122" bgcolor="white"><font

size="1" face="Arial" color="#461d5c"><b>Receipt

Date</b></font></td>

          <td width="127" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><b>Location</b></font></td>

          </tr>

          <% do while not rsscarr.eof %>

          <%

x=rsscarr(5)

y=rsscarr(7)

z=rsscarr(8)

summ1=summ1+x

summ2=summ2+y

summ3=summ3+z

%>

          <tr>

          <td width="90" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><%=rsscarr(0)%></font></td>

          <td width="80" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><%=rsscarr(5)%></font></td>

          <td width="87" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><%=rsscarr(1)%></font></td>

          <td width="105" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><%=Round(rsscarr(7),3)%></font></td>

          <td width="106" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><%=Round(rsscarr(8),3)%></font></td>

          <td width="95" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><%=rsscarr(3)%></font></td>

          <td width="92" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><%=rsscarr(11)%></font></td>

          <td width="122" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><%=rsscarr(2)%></font></td>

          <td width="127" bgcolor="white"><font

size="1" face="Arial"

color="#461d5c"><%=rsscarr(13)%></font></td>

          </tr>

          <%

          rowCount=rowCount+1

          rsscarr.MoveNext

          loop

          %>

    <tr bgcolor="#10337a" ><td colspan=1 align="right"

width="90" ><font color="white"><b>Sub

Total:</b></td><td colspan=1 align="left"

width="80"><font

color="white"><b><%=Round(summ1,3)%></b></td>

<td colspan=1 width="87"></td><td colspan=1

align="left" width="105"><font

color="white"><b><%=Round(summ2,3)%></b></td><td

colspan=1 align="left" width="106"><font

color="white"><b><%=Round(summ3,3)%></b></td><td

colspan=4 width="454"></td></tr>

<%

end if

total1=total1+summ1

total2=total2+summ2

total3=total3+summ3

rsstest.MoveNext

loop

%>

    <tr bgcolor="#10337a" ><td colspan=1 align="right"

width="90" ><font color="white"><b>Total:</b></td><td

colspan=1 align="left" width="80"><font

color="white"><b><%=Round(total1,3)%></b></td>

<td colspan=1 width="87"></td><td colspan=1

align="left" width="105"><font

color="white"><b><%=Round(total2,3)%></b></td><td

colspan=1 align="left" width="106"><font

color="white"><b><%=Round(total3,3)%></b></td><td

colspan=4 width="454"></td></tr>

<% end if %>

<% set rsscarr=nothing %>

<% set rsstest=nothing %> 

______________________________________________________



Please help me.

If I retrieve less no of records then there is no

problem.The error comes when I try to retrieve large

number of records.

Thanx

Regards

--Arshad--

     





__________________________________________________

Do You Yahoo!?

Send your FREE holiday greetings online!

http://greetings.yahoo.com

Message #7 by arshad siddiqui <ash_arshad@y...> on Mon, 24 Dec 2001 05:30:56 -0800 (PST)

Hi,

Merry chritmas

well the link you have provided there its givien the

fix for sql server 2000 but here I am using sql server

6.5.

What to do

Please help

Thanx

Regards

--Arshad--

--- Kim Iwan Hansen <kimiwan@k...> wrote:

> it usually helps if you check your error messages /

> descriptions on

> support.microsoft.com.

>

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q293318

> 

> -Kim

> 

> 

> > -----Original Message-----

> > From: arshad siddiqui

> [mailto:ash_arshad@y...]

> > Sent: 19. december 2001 05:51

> > To: ASP Databases

> > Subject: [asp_databases] Script keeps timing out

> >

> >

> > Hi,

> > I am now using stored procedures as suggested by

> > you,but still the same problem is coming.

> >

> > Microsoft OLE DB Provider for ODBC Drivers error

> > '80040e31'

> > [Microsoft][ODBC SQL Server Driver]Timeout expired

> >

> > /1024x768/stocklevel.asp, line 53

> >

> > Please help

> > Regads

> > --Arshad--

> >

> >

> > __________________________________________________

> > Do You Yahoo!?

> > Check out Yahoo! Shopping and Yahoo! Auctions for

> all of

> > your unique holiday gifts! Buy at

> http://shopping.yahoo.com

> > or bid at http://auctions.yahoo.com

> >





> > $subst('Email.Unsub').

> >

> 

> 





$subst('Email.Unsub').





__________________________________________________

Do You Yahoo!?

Send your FREE holiday greetings online!

http://greetings.yahoo.com

Message #8 by "Kim Iwan Hansen" <kimiwan@k...> on Tue, 25 Dec 2001 02:44:43 +0100

try this one then:

http://p2p.wrox.com/archive/asp_database_setup/2001-07/22.asp



the example's from sql server 2000 too, but take a look at it anyway.



hope it will do the trick for you :)



-Kim







> -----Original Message-----

> From: arshad siddiqui [mailto:ash_arshad@y...]

> Sent: 24. december 2001 14:31

> To: ASP Databases

> Subject: [asp_databases] RE: Script keeps timing out

> 

> 

> ---

> Need a present for your favorite programmer?

> E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp

> ---

> Hi,

> Merry chritmas

> well the link you have provided there its givien the

> fix for sql server 2000 but here I am using sql server

> 6.5.

> What to do

> Please help

> Thanx

> Regards

> --Arshad--

> --- Kim Iwan Hansen <kimiwan@k...> wrote:

> > it usually helps if you check your error messages /

> > descriptions on

> > support.microsoft.com.

> >

> http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q293318

> > 

> > -Kim

> > 

> > 

> > > -----Original Message-----

> > > From: arshad siddiqui

> > [mailto:ash_arshad@y...]

> > > Sent: 19. december 2001 05:51

> > > To: ASP Databases

> > > Subject: [asp_databases] Script keeps timing out

> > >

> > >

> > > Hi,

> > > I am now using stored procedures as suggested by

> > > you,but still the same problem is coming.

> > >

> > > Microsoft OLE DB Provider for ODBC Drivers error

> > > '80040e31'

> > > [Microsoft][ODBC SQL Server Driver]Timeout expired

> > >

> > > /1024x768/stocklevel.asp, line 53

> > >

> > > Please help

> > > Regads

> > > --Arshad--

> > >

> > >

> > > __________________________________________________

> > > Do You Yahoo!?

> > > Check out Yahoo! Shopping and Yahoo! Auctions for

> > all of

> > > your unique holiday gifts! Buy at

> > http://shopping.yahoo.com

> > > or bid at http://auctions.yahoo.com

> > >





> > > $subst('Email.Unsub').

> > >

> > 

> > 





> $subst('Email.Unsub').

> 

> 

> __________________________________________________

> Do You Yahoo!?

> Send your FREE holiday greetings online!

> http://greetings.yahoo.com

> 




> $subst('Email.Unsub').

>

Message #9 by "Ali Hijazi" <alimhijazi@h...> on Wed, 19 Dec 2001 08:42:55 +0200

assalam alaikom

did you include the adovbs.inc file?

this solves your problem!

it is located in c:\program files\Common Files\system\ado

----- Original Message -----

From: "arshad siddiqui" <ash_arshad@y...>

To: "ASP Databases" <asp_databases@p...>

Sent: Wednesday, December 19, 2001 06:51 AM

Subject: [asp_databases] Script keeps timing out





> Hi,

> I am now using stored procedures as suggested by

> you,but still the same problem is coming.

>

> Microsoft OLE DB Provider for ODBC Drivers error

> '80040e31'

> [Microsoft][ODBC SQL Server Driver]Timeout expired

>

> /1024x768/stocklevel.asp, line 53

>

> Please help

> Regads

> --Arshad--

>

>

> __________________________________________________

> Do You Yahoo!?

> Check out Yahoo! Shopping and Yahoo! Auctions for all of

> your unique holiday gifts! Buy at http://shopping.yahoo.com

> or bid at http://auctions.yahoo.com

>




$subst('Email.Unsub').

>

Return to Index

P2P Archives