We have an "API" that is written in ASP. Basically it is an ASP page that receive an XML Query string post and sends back a response as a "response.write". The ASP page does validation and SQL calls then eventually written to the SQL 2000 DB and send the response. This works perfect. It is similar how Authorize.Net users post transactions.
I am concerned about the availability and scalability of this. Our webserver is dedicated and the SQL DB is on a separate server (dedicated too). What happens when we have 100 concurrent users transmitting this query string to the ASP file? Will it freeze, hang, lose transactions? Is there a better way that does not re-writing in .NET or another language?
if some one provides some information about scalability and performance of ASP vs JSP. Scalability of JSP vs. ASP (which one is better?) Performance of JSP vs. ASP (which has better performance?)
I have been looking for graphs, and charts that compare JSP vs. ASP (scalability and performance) but I couldn't find any. If anyone knows any link which has scalability of performance graph of ASP vs. JSP, please let me know.
i have a task at work that i cant acomplish on my own. I have to create availability calendar of this type http://www.villarenters.com/advert_price.asp?ref=5731&rag=10821A&rcam=myvillarenters&sag=&sc=
and to make it work with our database. I try looking for the code of this type of calendars but i couldnt find anything . Please help me or tell me where i can find a script for this type of calendars (it must be a data base driven)
I have this textfield named idNum and users are supposed to key in their id numbers into the field eg (S1234567D, F1234567Z). The id numbers either start with a S or F followed by 7 numbers and then end with an alphabet (A-Z). How can i check if the id number the user keyed in is valid? I'm using VBScript to code and the format is something like that:
If Request.Form("idNum") = "" Then validateForm=False errorMsg = errorMsg & "Please key in your ID number.<br>" End If
Does anyone know where I can download an ASP based availability calendar, or have one that I can buy? I've trawled the web and can find plenty in CGI/Perl running on MYSQL but none in ASP running on MSSQL or Access.
I'm running a small villa rental website and need functionality like total cost of rental based on numer of days, different colours for days booked, two year forward looking, that kind of stuff.
In ASP (vbscript) is there a way to check to see if a SQL server is online before trying to open a connection?
I have a situation where we have a SQL server that may be offline for a couple minutes and right the ASP page returns:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I'd like to be able to first check to make sure the server is available and if NOT, then skip the database connection on that page altogether. Or, at least load the page without showing the error. I have on error resume next but it still displays this error.
A field such as name was created to perform a search to find a person. However, if that person is not found, the user can click on the add button and it automatically populates that last name field in the add student form.
Is that possible to do the same with the student id number - by putting in the student id number and if not found click on the add button and the student id is populated on the next form? If so, how? Any tutorials would be very helpful?
how to go about creating my own custom ASP page that can show several different peoples availability from their Outlook/Exchange 2000 calendars?I don't want to have to ask users to setup permissions for their respective calendars, i just want to be able to see if they're busy or not.
I am currently coding an accommodation rentals website and one of the searches required is an availability check.
At the time of booking you search for an accommodation that matches the accommodation type, no. of people and a start and end date from which to book.
I need to return a list of accommodations available using that criteria, I wanted to know if anybody has any ideas how to achieve this and do it efficiently.
at the moment i have a table that lists the accommodations and a bookings table that stores existing bookings.
I would like some help in having the form check to see if the selected course is available before submitting the info to the database and instructs them to choose another date if the course is closed. I have a qry that does a check and brings the information on availability. Any way to run that qry -check and send back the message or submit the confirmtion?
