Verifying a Database Connection

Question

There has to be a easy way to do this. I use dreamweaver to
do all my ASP web development. I have a particular application that
I want to verify if my database connection is available and, if so,
display an appropriate message. Pretty simple I think but I can't
seam to figure it out how to do it.

I though maybe a simple "IF... THEN... ELSE..." maybe, such
as

IF my_database is available
THEN write "The Database is available"
ELSE write "The Database is NOT available"
END IF

Does anyone know exactly what I need to write in order to do
this? In case you need to know I'm connecting to a MS Access
database.

Thanks!

Newsgroup_User · Answer

"CurtTheBeginner" <webforumsuser@macromedia.com> wrote in message
news:e4ap34$8uq$1@forums.macromedia.com...
> There has to be a easy way to do this. I use dreamweaver to do all my ASP
> web
> development. I have a particular application that I want to verify if my
> database connection is available and, if so, display an appropriate
> message.
> Pretty simple I think but I can't seam to figure it out how to do it.

this may be a little on the boring side, what what about having a recordset
on the page that has some sort of query that you now will return data... and
then have two small images (or two sets of text) and then do a "show region"
server behavior? If the recordset = true you show one bit of text... if the
recordset = not true you show the other item.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.