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.
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
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?
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.
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?
test my app? it's still in development but it's very much usable. i'm looking for few good object oriented souls that can look at this. i'm still adding few functions so don't be surprised if it goes down for a VERY short time (minutes really).
I need to revisit cookie testing. On the home page and every product page I write a cookie. I do this because some users enter by direct links to product pages.
<% Response.Cookies("cookietest") = ("49") Response.Cookies("cookietest").Expires = Date + 2 %>
On the cart page I test for the cookie...
<% If Request.Cookies("cookietest") <"49" Then Response.Redirect("err.asp?e=1") End If %>
I have a user that insists he has cookies enabled, yet he keeps getting redirected to my error page which suggests he does not have cookies enabled. What could cause this? Is the above too simple for all circumstances?
Is there more extensive code that I could setup on a hidden page where I can send users to get read out on how they actually have their browsers setup? i.e. Run a test on their browser and the results are emailed to me.
I know very little about ASP and ASPX pagfes but i inherited a web site done by a guy who knew just a little more than me and I've worked around things with my knowledge of HTML and Javascript, as well as added on to the web site using Cold Fusion. But I am at a point that I need to be able to do more.
I have a ASPX page with a Log In button that I don't want see if a certain cookie exists. Is there a way to test for that cookie on the page and display or not display something based on that test?
my system is at testing phase. how do i test my system to check its security especially at the login page? i am running it at localhost. i have tried sql injection but nothing happened. i just saw the invalid login username or password error only.
I have created a page that will allow all web based errors generated to be logged, like IIS errors 404, 403,401, 400.
I am now testing to see if the correct files are being displayed when the errors occur. I am able to replicate the 404 err as well as the 403 error, bu I cannot test the 401 or 400 errors. Does anyone know how to do this?
I tried using err.raise, but it doesnt seem to work, unless i m doing something wrong.
I need to test ASP pages at home before uploading them (no net connectiona t home, only here at uni and I need the site owrking before I transfer it). The ASP pages are written, PWS is installed (except for some file that had an error - but that didn't install last time and everything worked fine then). Where do I put the ASP pages and DB and how do I set up a connection between them? The pages run in IE at the moment but no data is pulled onto them from the DB.
I've been given a task to develop an automated unit testing framework for a project I'm workin on...
I've spotted ASPUnit on sourcesafe... but it doesn't seem to handle situations when we have global variables, session stuff etc...
I was thinking of doing something to a screenscrape and just do a file comparison... actually, there ARE ways to do this aren't there? I've heard/read about that before.. some HTTP objects or something that would allow me to call an asp page, and grab the output as a string.. rather than have the output go to a screen... anyone able to point me i the direction of this kinda stuff?
I need to test if cookies are enabled in the browser. I disabled cookies in my browser and rebooted my browser, yet the below code still writes a cookie and reads it correctly.
<% Response.Cookies("smcookietest") = ("8") Response.Cookies("smcookietest").Expires = Date + 2 %> <% If Request.Cookies("smcookietest") <> "8" Then Response.Redirect("error.asp?error=19") End If %> <%=Request.Cookies("smcookietest")%>
I am developing a Testing Checklist for the Programmers in my company. As i am not a programmer, Can you guys help me.
I am looking for some common Code testing steps which a programmer should do when he is testing his web application
These testing checklist could include common mistakes programmers do or any special coding error which they might receive when they are testing their web application.
I had a mild hack of the default windows web page in inetpub because I was running IIS whilst my DSL connection was on. Ever since,I have disconnected the DSL before running IIS.
Could anyone give me advice on running IIS safely as a local testing server (for asp pages) whilst online? I have to admit that I run an admin account (win2000) so I know this is one thing I should change
I'm running IIS under windows XP, and developing an ASP web page locally. My problem is that I can't get it to work without connecting to the internet. Am I doing something wrong, or does ASP require a redundant connection in order to run?
I have a page that simply displays the current time. If I'm connected and press the refresh button the displayed time is updated. If I disconnect, then the time displayed remains unchanged even after hitting the refresh button.
If I have 2 MS SQL Databases, one as Production and the other as Backup. The Production updates the data on the Backup. WHat I want to do is to test the the Production database is still online and if not I want to change the connection string to point to the Backup. I want to this via ASP.
I have a page where I am connecting to more than one server. I want to set it up so that if one of those connection fails it does not kill the whole page.
The page would still load but just display a little error message about the one failure - the other connection and code would still be executed... is this possible?
