I'm trying to figure out why some of my queries are timing out on me. Here's the setup.
Page
Pop-up window with drop-down menus and 1 iframe. Top section loads 1 time.. any search or changes in drop-down menu is transfered to the IFRAME by changing the source.
I notice if I have a total number of records not greater than 1000, this choosebox works just fine. If the total number is greater than 1000 then it's 50/50.
Problem
When I do a search or change the value of "Sort by" or change the value of "146 - 257" the application times out. I believe the timeout is set to over a minute. I look on the server and I see that DLLHOST.EXE is taking 50%+ of my CPU.
I tried the same query in SQL Query Analyzer and it pulls the correct records in no time. I also have a TEST QUERY page in the application and tested the data there and I get the correct records with no timeouts.
i have written some asp code on onclick of one button ,purpose is doing those work without submitting main form ,I am not getting working as files are not getting uploaded on web server any syntex error ? do u think this is write way to do so or suggest and modify code:
I have a site that utilizes online forms. The problem is people could easily spend well more than 20 minutes filling out the forms before submitting them. To avoid the default timeout of 20 minutes (or whatever) I added a Session.Timeout = 120 to the forms page. I also checked IIS and set the connection timeout property to 120 minutes as well.
sessions still seem to be timing out well short of the 120 minute cutoff. (I haven't yet tested to see if it's still 20 minute default or somewhere between 20 and 120).
Is there anywhere else this setting might be controlled? Is there any simple way to do some sort of "keep-alive" from the page so that the server thinks it's active?
A system I use uses advanced encryption for passwords. It was taken from some sample script and adapted some where. However this was I think intended to be for passwords. So nothing too long.
However the time has come where I need to create a function to encrypt a large amount of text. It has to encrpt a large amount of text but nothing too advanced is needed to be honest. Just so its unreadable because its written to a text file on drive. It has to be a function though then capable of decrypting the encrypted text.
Any ideas ? Again Dont have to be nothing too flash. I mean I had a go at just changing letters to different letters but the function got huge with all the replaces.
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I have an asp page that is producing a report via some heavy SQL queries with dynamically chosen parameters from the users of the page. I can run it on my development server (takes about 35 minutes to produce) , however when it is run on the production server it will execute for about 3 minutes, then bring me to a Page Cannot Be Displayed.
I think this might be some sort of timeout, but I have no idea as to how to stop it. I've changed the timeout property of the Server, I have even put in a buffer flush if the client isConnected.
I am using sql server 2000. From the asp page i am calling a stored procedure that does all the processing that includes:
1. create the query dynemically according to the selections made by the user. 2. run query 3. if records found, create a comma delimited list 4. pust that file on a file server, from where the user can then download the file
it return -1 if an error has accoured, 0 if no records are found, or file id if the records are found and file is written and moved to its location successfully.
i have increased the script timeout time to 800 ...
the default timeout for inactivity is 20mins, but in my application the clients are asking that if they are half way through an 'add a new record' page and disappear for 30 mins, when they come back the screen doesn't tell them they have timed out but lets them continue typing and its only when they hit 'submit' do they find out they have timed out. This then screws up the insert into dB type query and the data is lost. So what I am trying to figure out is a way (using asp if possible) to count the timeout inactivity and 19 mins in to go to another page (timeout.asp) which tells them that the session has timed out and that any data has been lost etc etc, this will then provide a link to the login page. The way the system is set up at the moment is that each page has a login script attached but is only shown if the session is valid, which has been working well. Does anyone have any bright ideas/links/tutorials etc
I support several intranet sites one of which had NO STATE. Even though content has ASP extensions, it was all rendered HTML. Site had NO session or application variables being managed. Site had no global.asa. IIS Manager had site timeout set to 20 minutes.We had to add an ASP include to pages, and that ASP include contained our first session variable. Users then started complaining of timeouts and being edirected to logout pages because session variable evaporated. Users requested a 4 hour - 240 minute timeout. This was set in IIS Manager on site, and it didn't work. We added global.asa with timeout set in session on_start routine, and even though we could display the timeout variable at 240 minutes, if we wait 30 minutes and pressed refresh on page displayed, it took logic path indicating session variable no longer set.
I need run a few large queries for one time only. But I get scripttimeout.So I set up server.ScriptTimeout value. It works fine.But for one query, system gives me the following error:
Microsoft OLE DB Provider for SQL Server (0x80040E31) Timeout expired
No matter how much I increase ScriptTimeout value, I still have the same error.is there a setting for SQL server timeout value?
I am having some trouble with internet explorer timing out. I have an asp page that writes all members email addresses to a second table and then I am using CDO to send them emails. I am using a function that waits 1 second between emails and then the page deletes that record.
I am sending close to 10,000 emails and everything is working fine, but when the emails are done the page is supposed to redirect. It does not and about half way through the emails it gives me a "page could not be displayed" error.
I have the script timeout set very high, do I think it is an IE setting, but have no clue and have not been able to find anything on this topic.
I'm using the following server: IIS5 Windows 2000 SP4 2 Processor Hyper thread enabled.
When creating HTML files with FileSystemObject the ASP page often times out (not every time though) and gives this error:
"The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools"
There are no loops on the ASP page. When IIS is restarted the problem disappears for a few hours then starts again.
I have an asp script that insert information into a SQL 2003 db table. The script works for about the first 3000 entries and then give me a.....
DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Obviously the server is there, since this is working for the first 3000 entries. I can then do a "where id> 3000" and run it again and it'll run about another 3000 then same error. What can I do to stop this error and have the entire process run?
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
I'm getting an error from something that seems too easy to cause trouble. Here's the scenario. User fills out a form. User saves. On submit, an asp script attempts to save the data. it deletes all of existing child records, and then re-inserts new child records.
Heres the chunk of code thats bombing out with a 'Microsoft OLE DB Provider for SQL Server error '80040e31' ':
'delete all children for this Parent record strSQL = "DELETE FROM qcspec_is_tasks WHERE parentID = " & nRecID debugPrint strSQL cn.Execute strSQL
The print statement yeilds the following, before the Execute statement dies:
DELETE FROM qcspec_is_tasks WHERE parentID = 20
If I run the above in query analyzer, it executes instantly.
Incidentally, at this point in time, the table is tiny. Its only 50 rows or so, at the moment.
I have a problem with sessions timing out while a student is taking a test. This is a really bad thing, because the session times out and then the student completes the test, but his answers aren't saved because the server no longer knows who he is.
I know that if I lag too long at my bank website a window pops up and tells me that I'm about to time out and to press a key if I want to continue.
I have a database that stores our banner ads. When the connection times out (it can't connect to the database), the whole website errors out. How can I set it so that if it can't connect to the database, then display an alternate image, so that at least the website loads?
Having some problems updating a recordset, despite the fact that I've used the bulk of the code sucessfully in other projects. I seem to be able to add records no problem, but when I try to update them I get Code:
My database server in another location. When I try to connect the database from my pc using asp page it connect successfully. But when I upload asp page to web it display connection timeout. eg: (web ulr as http://www.test.com/plan/conne.asp)
I have a session timing out after 10 minutes.If the user clicks a submit button to post some form data after the timeout has expired, they are redirected to a login page... Whats the standard practice for discovering what page they were headed to and how can I make sure that the form data is posted to that page so that no data is lost??? My assumption here is that the mechanism i'm using to redirect the user to the login page, needs to pass the original destination as well as the form data to the Login Form, and then the login form, once a proper authentication is performed, would redirect to the original destination allowing me to process the form data
I've been researching this issue with little luck. Here's the situation: We have a few users on slow dialup connections who are posting data from forms. Frequently, they get script timeout errors. We've gotten timeouts from users with faster connections as well, so I suspected that the overall load is overtaxing the server. But it does seem to be more frequent with dialup users posting relatively large (>10K) worth of data from forms. The Script Timeout value for the site is 20 seconds. IMO, it's seems quite odd that connection speed could influence a server-side script timeout, but... Question: When form data is posted, does the server begin processing upon receipt of the first packet with the post request, or does it wait until all packets have arrived? Question 2: Is 20 seconds too short, or are there potential problems with increasing it to, say, 30, 45, or even 60 seconds?
I've installed Fax Modem on My Windows 2000 Serer and Fax Service is running I can send Fax via notepad but when I tried to send fax from ASP I got nothing but a timeout error the ASP code as shown
dim FS dim FD
Set FS = Server.CreateObject("FaxServer.FaxServer") FS.Connect ("MachineName") Set FD = FaxServer.CreateDocument("c: empFax.txt") With FD .SendCoverpage = 0 .FaxNumber = "123 4 567890" .Send End With
I've developed a simple upload section of my site that allows the user to upload mp3 audio clips of new bands.
I've used AspUpload v2.0 as this is provided by my ISP, but even though these clips are no more than 500KB in size, the server is generating timeout errors.
I asked my ISP why this is the case and they said that the server timeout is set to 10 seconds so depending on the connection speed of the user who's uploading the files it will mean that they can only upload files of 200KB even on broadband.
I got this error when i run the ASP. ASP 0113(0x8004005).The maximum amount of time for a script to execute was exceed. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
I'm using IIS 5.1. I changed in the IIS instead of the asp page as there is a lot. I went to IIS then my application properties and go to Application Configuration. Under the option tab i set the ASP Script timeout to a larger value. Default is 90 seconds. I had set it to 180 seconds. May i know will this affect the system to become slower? As the users said in order to display something in the application it take longer time than previously.
Can anyone provide a simple example of an ASP script that includes timeout exception handling?Specifically, I don't need to extend the timeout, or prevent it. I'm not responsible for the DB, and I'm told that periodic timeouts will be unavoidable.
