Timeouts

I'm doing a query on a webproxy log, which is a pretty large table. I'm only doing a query on a single days worth, but could be upwards of 250000 records.

Originally I got a timeout error saying to increase the time using Server.ScriptTimeout so I put Server.ScriptTimeout = "900" at the top of my script. This didn't seem to help. Now I got this error: a.. Error Type:

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

This time it didn't mention what type of timeout I'm experiencing, at least, not that I can see. Code:

View Replies


ADVERTISEMENT

Session Timeouts - Have To Log In Twice

I have a couple of pre-built ASP scripts running on my site. One is a mailing list application and the other is subscription/user management app. The two aren't related - they were programmed by different people and use separate dbs.

I have a problem where the user has to hit the login button twice in order to succesfully login. On the mailing list app, as soon as I try to login the first time, I get an error that says "Your session has timed out".

Then once I re-login, everything is fine. The subscription app has the same problem in addition to timimg out very quickly if the user is inactive for even a couple minutes.

Do you think this is a problem with the way the web server is setup for session timeouts, or is there some code in each of these ASP scripts that need to be fixed?

View Replies View Related

Session Timeouts

is it possiable to have for example 2 sessions and that one of them will have 40 min timeout and the other session 60 min?

View Replies View Related

Changing SQL Timeouts

I connect to a databae with my ASP code to run special reports and every now and then the DB server seperate from the server I have the ASP on is really being used and I get SQL timeouts after 60 seconds.

to connect I use a DSN. Is there a way to set the timeout to 360seconds instead of 60 when using a DSN?

View Replies View Related

Avoiding Query Timeouts In ASP.NET ?

We are using ASP.NET on IIS5 to process requests
in a database.

How can one make choices in the .aspx based on
if a user has or hasn't changed a field? Is it possible
to control the ASP.NET environment by use of
some client side scripting ( ?changes=yes to URL)
or is there a way to tell in .aspx which Label elements
has changed?

Only solution i can think of currently is to query the
DB and then do an field by field comparision. Is that
the best way?

View Replies View Related

True Answer Re Timeouts

I've been using text files for Tab-Delimited/ADO/ASP sites so that users can
update and display their products lists through my system with relative
ease.

Only problem is that for the last few months or so, this system has been
generating loads of timeouts. ISP has said that I should be looking to
upgrade my system, as it is the mechanics of it that are creaking under the
strain. My queries are:

a) Which REALLY performs better OLEDB DSN-less or ODBC DSN-less?

b) If I convert the system to use 1 Access DB rather than 50-odd
tab-delimited text files will this REALLY perform better in relation to
timeouts?

To give you some idea of the problems, the site can viewed by going to
www.bardwells.co.uk and clicking the Product List link.

I just can't understand it because the pages on the whole are very lean and
zippy (esp. ADSL), but its these exact same Broadband users who seem to have
more trouble with timeouts than dial-up ones.

View Replies View Related

Client Timeouts. Need A Solution

we have a page, that posts some search results to the server.

however it takes a while to execute and return to the client.

we added a server.timeout = 120 to the asp script. but it still timesout

is there a "USER FRIENDLY" way to redirect the client to another page, pending execution of the server results ???

View Replies View Related

Data Access Timeouts

I'm beta testing a community membership site using ACCESS/asp on IIS5/windows server, shared with other sites. The performance is not consistent - sometimes OK, sometimes very slow and sometimes data access scripts time out (even when timeout set to 5 minutes) - sometimes the server recovers, and others a re-boot is necessary.

Can some one tell me if there are (or where I can find out if there are) performance issues involving 1. shared servers 2. incorrect data access set-up resulting in data access (e.g.concurrency/record locking, etc) problems 3. possible sloppy asp coding resulting un resource-hogging/non release, record locking etc.

View Replies View Related

Different User Session Timeouts

I want to have different user sessions timeout at different time intervals. How can we make this possible in ASP with and without using database tables.

View Replies View Related

Scripts, Large Rowsets, SPs And Timeouts...

I have an ASP page which pulls in, say, 800 records from a table containing ~ 1 million rows (and growing) - I use a command object and this calls a stored procedure, passing 5 parameters to the stored procedure from the querystring.

Now, if I run the stored proc from Query Analyzer, it takes between 25 and 40 seconds.

If I run it from the ASP page, if it takes LESS than 30 secs to generate then I get the output fine, but as soon as the 30 seconds elapse without anything being returned, I get a "Timeout expired" error.

I have taken the following action to eradicate, but all to no avail.

1.) Added Server.ScriptTimeout = 1000 into the page itself
2.) Upped the Script timeout figure in IIS for the application the report is within.
3.) Added a "Connect timeout=1000" line into my connectionstring (I was clutching at straws here...)

None of these alterations made any difference, so i'm a bit miffed.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved