I have an issue with handling concurrent users in asp page.
The server is win 2003.
Asp page calls a dll developed in vc++ for displaying reports from oracle database.
Application works fine for less than 10 users .but it fails with object cannot be intialized for more users.
I tested the same application in my m/c for load testing it supports 50 users without problem.
Iam wondering any settings at IIS or OS needs to be checked for supporting more users.
How do test my web application for concurrent users (how much concurent user connect at a time and how traffice will be affected and what will the response time?) and how it is done, how long it will takes, does it interfere with current site, etc.?
Reagarding the number of users the site will accomodate is it based on where it's hosted
Application written in ASP/Sql Server. Code:
How to do the error handling if the users key in character into integer text field? If possible, please give example and show me the coding.
View Replies View RelatedI would like to prevent a user from logging in with their user/password combination on a different computer or even a different browser window, if they are already logged in. I have a login page, from which I use a DB check to verify user/password info. Also, I have a bit loggedIN field in the DB, which I use to see if they are currently logged in; if so, I prevent them from logging in a second time.
Unless they click the "Log Out" button, then the DB value does not get changed. Any suggestions as to how I can log them out, even if they simply close the browser window or jump to a different page?
I have 4 ASP pages where an user can update some fields and submit the page, so that the fields are updated in the Database(Sqlserver), I need to handle one situation.
1) At a time I need to allow only one user to update the details in a page.
2) I need to stop other users who are trying to access the same page concurrently(probably with a message or Redirecting to other page where he can see the details in a report format).
3) Session timeout in my application is 60, So if the first user leaves the page open for a long time , I think it would be a problem....the other session has to wait for a long time.
I have no choice in decreasing the session timeout interval.
Please suggest , How can I handle this in ASP.
help me regarding the concurrent user for crystal report. im using asp classic. how can i prevent the concurrent error? and also stop the server from sending me an error report directly to my mail? the error is asp 0194.
this is related to concurrent users of crystal report upon reaching the limit. i would like to stop the sending or stop the error if ever so that i will not be recieving the error message.
I want to be able to log in a database any transactions my users perform. For example logging in, requesting a page, downloading a resource, logging out etc.
What is the most practical way to code this? I was thinking of trying to use an include file which would have a function to add a log in the database for each page on the site or when a particular action is performed.
I have been trying to find a script on the net that would allow me to handle directory listings through ASP. I'm basically looking to change the default generated pages when browsing directories. Eventually I would love to be able to change which directories/files show based on permissions and be able to allow uploads to current directory listings.
View Replies View RelatedI am attempting to use url's on a database driven webpage - the url's are really ugly (created by mapquest) - I have tried to put " quotes " around the urls in the database as well as without - but all i get is a blank about page, can anyone help.
Here is my code:
<td><a href="<%Response.Write(rs("Directions"))%>" target="_blank">Directions</a></td>
How do i do error handling using asp. Like taking an example i am getting this error on trying to save a record twice whihc has a primary key constraint:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
how can i handle such cases and where do i place the code???
I have a piece of code which causes an exception. Now i don't know why that is. I would like to know the best way to debug the exception.
I know about try and catch statements. However with these you need to have a basic idea of the type of exceptions that could occur. Does someone have a better suggestion on how to debug an exception?
I’m trying to write a script that will select some records from an Access database within a certain date range one of the fields is a date. Code:
View Replies View Relatedsql = "SELECT * FROM Calls WHERE Date BETWEEN " &startdate& " AND " &enddate
Where did I go wrong?????????????
Ugly response:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
I want to error handling in ASP. But i think that ASP is not enough for
error handling. I have got two chance.
1. I can prapare an error page and control throught IIS.
2. I can use on error resume next.
For 1. This is a general handling. I want to handle local error. Maybe i do
special thing when error occured.
For 2. I have to write alot of lines code. I have to control every line.
if I have two strings as follows :
"1,3,45,65,777,89,00
and
"8,9,67,54,89,23
The numbers represent a predefined access permission to a certain file.
I need a function to sift through the first string, and compare it to the second string. What numbers are located in the second string, which are are located in the first string need to be removed (from the second string) leaving only unmatched numbers beind.
how use the array handling in asp
View Replies View RelatedIs there a possiblity that, when an error comes in asp page in server, especially with sql script, to hide that error from user and display just Error, report to admin,
i just want to make a general case where when an error comes i should take the page to report to admin.
im following all single quotes as follows:
email = request.form.item("email")
email = Replace(email, " ' ", " ' ' ")
so as not to crash my database. Only problem is, when i take a value out of the database it now has two quotes instead of one (example Linda D'Agostini --> Linda D''Agostini)
i want to create a long string and save it inside rs("history")
what is the best way to save texts every action. with comma(,) in the end?
and how when i want to view the list i will be able to add <br> after every comma in order to view this all list normaly?
Can you please help me with event handling (for eg: capture key press, mouse overs, mouse_over drop-down menu, on_click drop down box) in asp.
View Replies View RelatedI am using global.asax to handle my web application exceptions and have
configured it to create event log entries for errors that occur and to
display an error page advising the user to contact the helpdesk.
I have an intermittent uninitialised object error that I am not able to
reproduce in test and for which I really need the source line number.
I believe this information is contained in the PDB but am not sure if one is
created if I set the debug="true" flag in the compilation part of the
system.web section of the web.config when the application is recompiled.
I want to handle events of the AO Connection object in my ASP page. How can I do it?
View Replies View RelatedI have written some code to query a database and create a hyperlink based on a value, however, if the value comprises of more than one word, the hyperlink only references the first part of the value. e.g. For instance, if the value retrieved is "the strokes", the hyperlink will only contain the word "the".
Here is my code: ....
i have a scenario where i have to serve users of my site questions on daily basis,but before they can answer a question they must answer a previous question correctly served previously before the current day .
This means to me that i have to keep a log of each questions served each day and users response whether they attempt the questions or not .i am scared to keep a scenario of a million users each day,their actions on a particular questions.what is the smartest way to achieve this.
We are interfacing an ASP page with a COM object. In the COM object, if there is a condition that makes it not possible to perform the requested action, an exception is raised that can be caught by the calling application.
When an exception is raised by the COM object during the processing in the ASP page, the processing seems to lock up on the ASP side on the line of the function call that raises the exception.Has anyone else ran into similar issues? If so, how can we work around them?
How i can handle the errors in ASP. Please suggest something.
View Replies View Relatedhow i can handle errors on ASP page. Actually i want to maintain a ErrorLog in Database and want to redirect the user on an Error.asp page where i can show him the error details(i-e error #,Description etc).
I have found "With Endwith" method to handle errors but the problem is that i can only write it with a record set and it will handle only record set related errors and also i have to write With EndWith with each recordSet but i want to handle any error on page at a single place.
I have a dynamic asp page that takes input from a url. IE: parts.asp?sku=543 From there it looks up the sku in a database and outputs the part information. Currently if you put in an invalid sku that is not in my database, you just get a Internal server error.
Whats the correct way to give a 404? Do I just do a Response.Redirect to my 404.asp page if the recordset is empty?
I'm using a Firebird database to store user comments using my web app that I wrote in ASP. Some fields are mandatory. some are not. Whenever I leave the textareas blank, Firebird stores them as empty text. Anyhoo, the blob fields are subtyped to text 80 segments wide.
I'm using reponse.binarywrite() to output the text into text areas. If there is something in those blob fields, all goes well. But if there isn't anything in the blob fields or I leave a couple of the blob fields blank, the program crashes. So I decided that I want to check if there is something in the blob field, before binarywriting it. I tried comparing it to the string "" and checking to see if it's null but to no avail. Something about a type mismatch error. The exact error message is:
Response object, ASP 0106 (0x80020005)
An unhandled data type was encountered.
/tracking/updateproject.asp, line 314
line 314 is where I'm binarywriting the blank data.
I have an edit form for records that belong to numerous categories. Records are joined to categories with a join table in a many-to-many relationship.
When displaying a record for editing I loop through the category recordset, looping through the entire join-table recordset for each category, to tick (or not) each checkbox as it's displayed.
This seems like a costly way of populating checkboxes. Is there a more elegant solution?
Like File Uploading, Can I browse a file from local and when i click ok, The file should be read and update the DB. Code:
View Replies View Relatedcan anyone tell how to handle exceptions in ASP. please give me any link or explain me if possible.
View Replies View Relatedwhat this code doesnt work?
<%
on error goto errhand:
exit sub
errhand:
response.redirect("error.asp")
%>