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 Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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:
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?
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?
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?
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 ???
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.
SPLIT Either BOF Or EOF Is True?
I'm pretty new at this so if someone could tell me what I need to do to the foloowing code I would really appreciate it! strSQL = "SELECT * FROM chapmeetreq2 WHERE chapter = '" & session("chap") & "' and entrydate = '" & date() & "' order by req_id desc" ...
True Or False In A Yes/no Field
in one of my sql queries on an asp page i am trying to select some data from an access table. The problem is the search criteria is based on a yes/no field. I need to find any record where the value is null or true. So far i have this: if ISNULL(orseof("Returned")) OR orseof("Returned") = True then the ISNULL section works it is just the = true bit that doesn't.
True Image Thumbnails
How can my ASP serverscript read a JPG file and create a small thumbnail image? I don't mean simple resizing, but true resizing so that the image actually gets smaller in size. Is this possible without the use of a 3rd party component?Does anyone have a code example for me?
Subscript Out Of Range: 'True'
I'm getting this error: Microsoft VBScript runtime error '800a0009' Subscript out of range: 'True' /Featured.asp, line 28 on this code:
True Or False Quiz
i m trying to create a true and false quiz which accesses the questions from a access database processes the results and then writes back to the database I dont know how to structure the code for the radio buttons,i also need to give the user immediate feedback, but i cant use pop up boxes
Isnumeric Return True
why does isnumeric return true? a="" if isnumeric(a) then response.write("test") end if empty isnt numerical is it?
Either BOF Or EOF Is True, Or The Current Record Has Been Deleted
ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. This is the error I recieve when trying to run my site. I know why. I am passing a non existed URL Parameter. However I would like to recieve a MsgBox that says that such record doesn't exist. Code:
Either BOF Or EOF Is True, Or The Current Record Has Been Deleted
I have several pages I set up in my web site and I am having trouble with two of them - search and results. The stat_search uses a form which seems to work right and when I test the recordset on the stat_results page and enter a value it returns the right results. When a value is entered from the stat_search page the results page displays the records with the right value and the Records _ of _ indicates the right number of records but when I use the Next or Last arrows to move to the next record I receive the ADODB.Field error. Code:
Either BOF Or EOF Is True, Or The Current Record Has Been Deleted.
This is the error I'm getting: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /ism5315/readtrends.asp, line 46 What I'm trying to do is select the records from my table that match the sensor and gauge the user selects. I have time fields that are optional, and I'm trying to get the page to work if the user selects no time frame first. Of course, there can be mutliple records for the gauge and sensors, so I created a loop that should run thru and select them all. But I am getting the above error. But I know I am getting into the loop because I have included a response.write sql to verify I am selecting the correct objects. Code:
Random True/false Quiz
Here's what I want to do (i'm kind of there in JavaScript, but want to move it to ASP). I have 17 different html pages. quiz1.html > quiz17.html. The user says take a quiz and it pops up a window holding quiz1.html. Within each page is a true/false question. Upon answering the user is told: 1. what they answered. 2. if that is correct or not 3. a corresponding sentence about the question. 4. an image the corresponds to if they were corect or not. (This is all done in javascript). ---- However, now I want to take these 17 questions and randomize them and choose 6 questions. For example: The window pops up and it's question 1 they do that then move to the next one. 1-6 (random out of 17. I'd like to do this in ASP.
ASP VBScript Fails When Response.buffer = True
I have a big asp file that has an error under certain conditions -- totally repeatable. However, it only fails when I set response.buffer = True at the top. WHen I set it False in order to debug it, it works every time! I even set it to True, but did a .Flush just before the error, and the error won't happen. It only happens when response.buffer is True and no .response.flush is issued. The error is a string variable turns-up empty and crashes a function requiring a date. I could test for this before the line where it crashes, but where did my data go? Why is the buffer affecting it?
|
TRACKER
