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

Testing Of Concurrent Users/ Load Testing

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

Cookie Availability

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

ASP And Availability/scalability

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

Availability Chek

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

Check Availability

how can i create a button/link to check availability of a user ID against a an ID field. Code:

View Replies View Related

Check Availability

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

Availability Calendar

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

User Availability Validation

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

Attendee Availability Online

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

Availability Check Efficiency

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

Domain Availability Function

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

Check Availability Of Data

how to check the availability of data in table. If there is, I want a messagebox to prompt the users.

View Replies View Related

Verify Availability Before Submitting A Form

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

Component Or Code To Ckeck The Availability Of A Domain

Somebody know a component or code to ckeck. The availability of a domain?

View Replies View Related

App Testing.

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

Cookie Testing

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

Testing ASP Cookies Using IIS On Win XP Pro

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

Testing For A Cookie

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

Security Testing

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

Error Testing ASP And IIS

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

Testing Scalability

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

Testing ASPs

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

Testing Tool

May I have the list of good ASP testing tools available on the market?

View Replies View Related

Testing ASP Locally

When I type in the url...URL I get an error saying I'm unauthorized to view the page?

View Replies View Related

Unit Testing

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

Testing For Cookies

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

Code Testing

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

Testing Web Server

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

Testing Without Connection

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

Testing Tool

May I have the list of good ASP testing tools available on the market?

View Replies View Related

Testing A MS SQl Connection

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

Testing Connection

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







Copyrights 2005-15 www.BigResource.com, All rights reserved