|
 |
asp_database_setup thread: session timeout
Message #1 by dparkins@m... on Tue, 17 Jul 2001 15:03:40
|
|
I'm trying to access an sql2000 table that contains 2.5+million records
but I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/sales2.asp, line 20
I've looked everywhere but have not figured out how to extend the timeout
period. Is it in the global.asa. And if so could I get an example or could
it be something else. The web server I'm using is also a 2000 machine.
Thanks in advance,
Dave
Message #2 by "Drew, Ron" <RDrew@B...> on Tue, 17 Jul 2001 10:02:35 -0400
|
|
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionTimeout = 0
-----Original Message-----
From: dparkins@m... [mailto:dparkins@m...]
Sent: Tuesday, July 17, 2001 10:09 AM
To: ASP Database Setup
Subject: [asp_database_setup] session timeout
I'm trying to access an sql2000 table that contains 2.5+million records
but I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/sales2.asp, line 20
I've looked everywhere but have not figured out how to extend the timeout
period. Is it in the global.asa. And if so could I get an example or could
it be something else. The web server I'm using is also a 2000 machine.
Thanks in advance,
Dave
Message #3 by Pedro Andrade <pandrade@n...> on Tue, 17 Jul 2001 15:09:08 +0100
|
|
Hi Dave!
Try something like that :
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionTimeout = 0
This sets the connection to no timeout.
Hope that works with you.
Pedro Andrade
dparkins@m... wrote:
>
> I'm trying to access an sql2000 table that contains 2.5+million records
> but I get the following error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
>
> [Microsoft][ODBC SQL Server Driver]Timeout expired
>
> /sales2.asp, line 20
>
> I've looked everywhere but have not figured out how to extend the timeout
> period. Is it in the global.asa. And if so could I get an example or could
> it be something else. The web server I'm using is also a 2000 machine.
> Thanks in advance,
> Dave
--
_____________________________________________
Pedro Andrade
N E T V I T A
Information Systems
Tel: +351.239.700910
Fax: +351.239.700911
http://www.netvita.pt
mailto:pandrade@n...
_____________________________________________
Message #4 by Dave Parkins <dparkins@m...> on Tue, 17 Jul 2001 09:33:53 -0500
|
|
Thanks for your tip Pedro, unfortunately I tried it and it doesn't work. I'm
using Dreamweaver UltraDev4 and the coding for database connections is a
little different. I got the following error:
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method:
'Recordset1.ConnectionTimeout'
/sales2.asp, line 16
The following is what the connection looks like with your line of code:
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_LPWeb_STRING
Recordset1.ConnectionTimeout = 0
Recordset1.Source = "SELECT Col009, Col001, Col004 FROM dbo.dir_usa WHERE
Col009 = '" + Replace(Recordset1__type, "'", "''") + "' and Col004 = '" +
Replace(Recordset1__state, "'", "''") + "'"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
Dave
-----Original Message-----
From: Pedro Andrade [mailto:pandrade@n...]
Sent: Tuesday, July 17, 2001 9:09 AM
To: ASP Database Setup
Subject: [asp_database_setup] Re: session timeout
Hi Dave!
Try something like that :
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionTimeout = 0
This sets the connection to no timeout.
Hope that works with you.
Pedro Andrade
dparkins@m... wrote:
>
> I'm trying to access an sql2000 table that contains 2.5+million records
> but I get the following error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
>
> [Microsoft][ODBC SQL Server Driver]Timeout expired
>
> /sales2.asp, line 20
>
> I've looked everywhere but have not figured out how to extend the timeout
> period. Is it in the global.asa. And if so could I get an example or could
> it be something else. The web server I'm using is also a 2000 machine.
> Thanks in advance,
> Dave
Message #5 by Pedro Andrade <pandrade@n...> on Tue, 17 Jul 2001 15:47:50 +0100
|
|
Hello Again Dave,
That's right. You can't use the "ConnectionTimeout" property in a
"recordset" ADOBD connection. Tou must use a "ADOBD.Connection" instead
of "ADODB.Recordset".
Hope that helps.
Pedro Andrade
Dave Parkins wrote:
>
> Thanks for your tip Pedro, unfortunately I tried it and it doesn't work. I'm
> using Dreamweaver UltraDev4 and the coding for database connections is a
> little different. I got the following error:
> Microsoft VBScript runtime error '800a01b6'
>
> Object doesn't support this property or method:
> 'Recordset1.ConnectionTimeout'
>
> /sales2.asp, line 16
>
> The following is what the connection looks like with your line of code:
> <%
> set Recordset1 = Server.CreateObject("ADODB.Recordset")
--
_____________________________________________
Pedro Andrade
N E T V I T A
Information Systems
Tel: +351.239.700910
Fax: +351.239.700911
http://www.netvita.pt
mailto:pandrade@n...
_____________________________________________
|
|
|
View Cart
