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
ADVERTISEMENT
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
View Related
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
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
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
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
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
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
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
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
Last week I posted in the graphics forums regarding a photo I have that I needed to slowly change from day to night.Now I have the various stages, I need them to display on my site, according to the time of day.For example:
Between 5am and 7am display the early morning picture
Between 7am and 5pm display the day picture
Between 5pm and 7pm displayy the evening picture
and so forth.
View Replies
View Related
I'm having a domain change foisted upon me and the test I did resulted
in every last ASP and
ASP.Net script stopping cold. Nothing but plain old html worked.
Is there a FAQ or some other document available that outlines what has
to be done when the
IIS server machine is disconnected from one domain controller and
reconnected to a totally different one? If not, does anyone here know
what would have to be changed to make the ASP code play nice in the new
domain?A relevant bit of info, they're also changing the name of the
administrator account. I don't know if that would contribute to the
death of ASP* on the system, but it might.
View Replies
View Related
i have an insert record and edit record page. When inserting to the db, it uses now(). When I go to edit an existing record the date stays as the original date. How do I make the date change to the amended edit date?
View Replies
View Related
I have used ASP for years using MS Access and have used MSSQL quite a lot as
well. I have never came across something like this before.
MSSQL table names and types:
ProductName nvarchar
ShortDescription nText
ThumbNail nvarchar
etc
When I have the recordset in the order as follows, all works well:
(Recordset2.Fields.Item("ProductName").Value)
(Recordset2.Fields.Item("ShortDescription").Value)
(Recordset2.Fields.Item("Thumbnail").Value)
Though if I have the Thumbnail first the description does'nt show.
View Replies
View Related
how best to convert an application which is all in English to be able to roll the app out to say Germany or France and it all appears in the correct language
View Replies
View Related
My site uses frames.I have a header frame, a menu frame and a main frame. When the page opens, the header frame and the main frame are generic. The main frame has a log-in dialog. Once the user logs in, they are taken to a 'main' page and I want to replace the header and menu frames with other frames .
View Replies
View Related
I need to set up an HTML table or the like, with 4 columns.
Each column needs to have a header with a FRIDAY (dd/mm/yy) date.
i.e. this weeks Fridays date is 16th Feb, the following is 23rd Feb
etc.
So, I need column 1 to be headed 16th Feb, col 2 to show 23rd Feb etc.
As this week passes, the dates need to move up 1 week, so that next
week, col 1 will display 23rd Feb and so on.
These headers need to change according to the date.
Please can you advise how I best achieve this ?
View Replies
View Related
I was talking to someone back at Uni. He showed me his web site. He had - and + to increase the size of his web page or to decrease it so the user can always see everything on screen.
He did it in asp. I'm interested to know how it was done.Does anybody know how to do this?
View Replies
View Related
I have two textbox in the form. what i want to do is update the second text box based on the sponsorid entered by the user. I want to display the member name based on the memberid which is retrieved from the database on the bases of entered sponsorid by the user.
i extracted all the data when the page loads from the database but unable to call it on blur event of the text box. The variables cannot be accessed in the vbscript because these are for server side and not accessable on the client side. What is the way around this problem.
View Replies
View Related
When I create a simple page with this code, the sessionID shows differently
each time I refresh the page.
On every other refresh it is blank, on every other, it is new. What is
happening here?
Dim sessStr as String
sessStr = Response.Cookies("ASP.NET_SessionId").Value
Response.Write("Session ID=" & sessStr)
View Replies
View Related
i am running iis and apache both.now i want to change the port of iis to e.g 70.how can i change it?
View Replies
View Related
I want to convert the first character to Upper case, while the rest remain lower case.
variable = lcase(left(blablabla,9))
let say now the "variable = abcdefghi"
How can I convert ONLY the first character to uppercase?so that the variable will be holding "Abcdefghi" ?
View Replies
View Related
i want to know how to change the password or replace it with new password and for more details see the attachment. note that i am using Dream weaver for development and Access database to save users information.
View Replies
View Related
I have domain name, eg www.abc.com. Use the Dynamic DNS web site to register. How the IP of www.abc.com. can be shown once I click The Domain Name,e.g.click http://www.abc.com.
Then show http://123.123.123.123
Is it the ASP program can help me? or any other solution.
View Replies
View Related
I am running a marquee across the top of my page. The text for the marquee is initially loaded from a SQL Server Database. However, as users look at this page the text may be updated by an administrator of the site.
To account for this, I tried to use VBScript to code the onstart event of the marquee. In the script I was trying to check for updated text but I don't believe it is possible as it seems the database code only runs on initial loading of the page. Any ideas on how to requery the database for the updated text?
View Replies
View Related
I run a site using a blog script (dblog) where if you want to open an article from the homepage, it links to a page called article.asp. For example if I want to open article 101 the link goes to article.asp?article=101 but the title (the metatag) is always the same.
What I want to do is having the title change from article to article, retrieving it from the database. So if I open article.asp?article=101 the <title> displays the title of the article 101.
View Replies
View Related
However when the results are listed and a file link is clilcked the browser is looking at the local drive for that users PC i.e c:. Is there something I can do to make it look on the local drive of the server? This is for internal network use, so there would be no security implications.
<% If rstResults.Fields("doctitle") = "" Then %>
<strong><a href="<%= PathToVpath(rstResults.Fields("path")) %>"><%= PathToVpath(rstResults.Fields("path")) %></a></strong><br />
<% Else %>
<strong><a href="<%= PathToVpath(rstResults.Fields("path")) %>"><%= rstResults.Fields("doctitle") %></a></strong><br />
<% End If %>
View Replies
View Related
i have a login form on my site. if the user enters incorrect detaisl then the script will kick them back to the page they were viewing before submitting the login form (login box is on all pages) using: Code:
View Replies
View Related
Is there a way in code that is, to be able to change the URL extension say:
www.myhomepage.com/home.asp
to
www.myhomepage.com/home.mxxx
View Replies
View Related
I have a total cost listed on my page, followed by 3 radio buttons named postage. What i would like is for the total price that is displayed on the page to change depending on radio button that is clicked e.g. US Rate, UK Rate, Eur Rate. Im not sure how to do this without sending submitting the form to a new page which is not possible given this situation.
View Replies
View Related
I am installing phpBB and it says that i need to change the permissions on config.php to be writebale by all (666 or-rw-rw-rw within your FTP Client). does anyone know how to do this. I have tried right clicking and going to permissions but i do not see anywhere to change it to 666 or -rw-rw-rw .
View Replies
View Related
I would like to change an ASP module using ASP and an ASA routine to dot NET to take advantage of some dot NET features. Do I simply change the ASP and ASA extension to aspx and asax? I tried this and got errors.
View Replies
View Related
How do you do it? I have a ASP variable defined at the top of the page but how do I change that variable to a javascript one?
View Replies
View Related