CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Query timeout problems

Print topic Send  topic

Author Message
dgk
Posted: 10/24/2003, 7:00 AM

ASP.NET VB SQL2K

I'm need to create pages that require long queries (like 5 minutes). I keep getting timeout exceptions, either SqlExceptions or OleDbExceptions, based on which driver I use. Either way, I can't figure out how to extend the timeouts.

I can't find a place in the CCS GUI or the generated code where I can edit command timeouts. Does anybody know how to do this??

Thanks in advance!
dgk
ryan
Posted: 10/25/2003, 1:21 AM

ASP.NET VB SQL2K

First the queries can be optimized if you use stored procedures then you must close recordsets occassionally.

Using CCS you need not to create connection use the CCS connection DBConnectionName.Execute, reuse it it's a class already so it's faster.

Then for extending timeouts, I have to do this when I am accepting file upload only that but you just add this line where the Dim (declarations) are placed
on common.asp or since you are using ASP.NET maybe on the config or somewhere I do not know ASP.NET can still accept ASP right?


Server.ScriptTimeout = [seconds] '120, 400, 1000 ???

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.