-
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
-
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
-
Forum Rules
|
|