Timeout expired

Results 1 to 2 of 2

Thread: Timeout expired

  1. #1
    Mark Guest

    Default Timeout expired

    Does anyone know how to increase the query timeout.<BR>I&#039m using SQL 7.0 and trying to run a SP. This SP worked fine before now there is 23000 records in the DB and I get the error <BR><BR>Microsoft OLE DB Provider for SQL Server error &#039 80040e31&#039 <BR>Timeout expired <BR>/Project3/IPOReports/report_main.asp, line 78 <BR><BR>I&#039ve tried increasing the scripttimeout but it didn&#039t help.<BR> <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Timeout expired

    I think this is how you do it. You can increase the number after Connect.ConnectionTimeout. Hope this helps!<BR><BR>Set Connect = Server.CreateObject("ADODB.Connection")<BR>Connect .ConnectionTimeout = 20<BR>Connect.Open "DSNName"<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts