im kind of new to this any help would be great, 
when i try to connect to the SQL2000 database i get this error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Timeout expired
/collages/indexhome.asp, line 17

if some one could give me any infomation on what is causing this it would 
be greatly apperciated, if you need any more info to help you help me let 
me know ill do my best. thanks in advance, brian

Hi Brian,

The default SQL query timeout for ASP is 90 seconds.  So either you have a
large query that just takes time or you may have an endless loop.  If you
open IIS Admin, select your web site and go to properties.  Select the Home
Directory tab and click on the Configuration button.  The second tab; app
options has a value for ASP timeout.  This value is in seconds and is
probably set to 90.  Up this value to give your query more time to finish.

Cheers,
Eli

-----Original Message-----
From: Brian Schreiner [mailto:bschreiner@c...]
Sent: Monday, March 25, 2002 8:46 AM
To: ASP Database Setup
Subject: [asp_database_setup] ASP error


im kind of new to this any help would be great, 
when i try to connect to the SQL2000 database i get this error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Timeout expired
/collages/indexhome.asp, line 17

if some one could give me any infomation on what is causing this it would 
be greatly apperciated, if you need any more info to help you help me let 
me know ill do my best. thanks in advance, brian
%%email.unsub%%

This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=_376A99A6.FE9FF9F9
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

eli,
THANK YOU very much that worked out great i really appreciate your help 
and quick response, not to mention you made me look good in front of my 
boss. i really appreciate help!!!!!!!!

thanks brian


>>> eschilli@t... 03/25/02 11:43AM >>>
Hi Brian,

The default SQL query timeout for ASP is 90 seconds.  So either you have a
large query that just takes time or you may have an endless loop.  If you
open IIS Admin, select your web site and go to properties.  Select the 
Home
Directory tab and click on the Configuration button.  The second tab; app
options has a value for ASP timeout.  This value is in seconds and is
probably set to 90.  Up this value to give your query more time to finish.

Cheers,
Eli

-----Original Message-----
From: Brian Schreiner [mailto:bschreiner@c...]
Sent: Monday, March 25, 2002 8:46 AM
To: ASP Database Setup
Subject: [asp_database_setup] ASP error


im kind of new to this any help would be great,
when i try to connect to the SQL2000 database i get this error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Timeout expired
/collages/indexhome.asp, line 17

if some one could give me any infomation on what is causing this it 
would
be greatly apperciated, if you need any more info to help you help me 
let
me know ill do my best. thanks in advance, brian
m
%%email.unsub%%


net
To unsubscribe send a blank email to leave-asp_database_setup-1065585Q@p...
wrox.com

to unsubscribe send a blank email to leave-asp_database_setup-1065585Q@p...
wrox.com.