Testing For SQL Availability In ASP
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.
View Replies
ADVERTISEMENT
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:
View Replies
View Related
If my user turns cookies off, both permanent and temporary cookies can't be used or only permanent cookies can't be saved on the user's machine?
View Replies
View Related
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?
View Replies
View Related
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)
View Replies
View Related
how can i create a button/link to check availability of a user ID against a an ID field. Code:
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
Can anyone offer a good reference for a domain avialaibility checker? I'd like to create a web page to see if domains are available or not.
View Replies
View Related
how to check the availability of data in table. If there is, I want a messagebox to prompt the users.
View Replies
View Related
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?
View Replies
View Related
Somebody know a component or code to ckeck. The availability of a domain?
View Replies
View Related
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).
View Replies
View Related
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.
View Replies
View Related
I'm sure I have missed something but I can't see what...
I create two cookies on one ASP page as follows:
response.cookies("Errors") = "Must not be blank"
response.cookies("User")("Mem_Username") = response.write(M_Mem_Username)
response.cookies("User")("Contact_N") = response.write(M_Contact_N)
This page then calls the second ASP page which then reads the cookies:
E_Contact_N = request.cookies("Errors")
C_Contact_N = request.cookies("User")("Contact_N")
C_Mem_Username = request.cookies("User")("Mem_Username")
When I then use response.write (for example, response.write(C_Mem_Username)) to view the contents of the variables, there is nothing there.
As I say, I am still developing the site and so am using IIS on a Win XP Pro machine (local host)
What I am doing wrong?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
How can I test the scalability of my website, e.g how can I check if my website still performs correctly when there are 300 people visiting?
View Replies
View Related
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.
View Replies
View Related
May I have the list of good ASP testing tools available on the market?
View Replies
View Related
When I type in the url...URL I get an error saying I'm unauthorized to view the page?
View Replies
View Related
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?
View Replies
View Related
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")%>
View Replies
View Related
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.
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
May I have the list of good ASP testing tools available on the market?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related