Results 1 to 2 of 2

Thread: MS SQL Server timeout

  1. #1
    Join Date
    Mar 2004
    Posts
    1

    MS SQL Server timeout

    Hello
    I am using ASPdb to generate some internal reports. I am using a complex query on a database with approximately 640000 records. It gives me the following error.

    Error # (Get_RS_GetCount - After open mySQL) = 80040E31(-2147217871) Description = [Microsoft][ODBC SQL Server Driver]Timeout expired Source = Microsoft OLE DB Provider for ODBC Drivers SQL State = S1T00 Native Error = 0

    I have set the server timeout to 900 and also the database connection timeout to 2000. It still gives me the same error. However if I simply use ASP this query works fine.

    Is there any work around for this in ASPdb.

    Thank you

  2. #2
    Join Date
    Oct 2002
    Posts
    933
    depends on what you are doing. 640K records means not a whole lot. The demo example in the site (performance) has 330K records and your finger hardly lifted away from the keyboard before it returns a query of 50K records (use Dallas as filter).

    If you can backup your DB, zip it and send to me, I'll take a look for you.


    FK

Posting Permissions

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