Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - How do I check my db is running
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How do I check my db is running

 Post Reply Post Reply
Author
kevinhann View Drop Down
Newbie
Newbie


Joined: 02 February 2004
Location: United Kingdom
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote kevinhann Quote  Post ReplyReply Direct Link To This Post Topic: How do I check my db is running
    Posted: 02 February 2004 at 1:38pm

I often get complaints that my web sites are not working due to the access registry problem.

I want to build a page that will run on my unattended pc and send me an SMS message when the db fails.

Any ideas on the best way of checking that it is running? I have a few ideas but dont want to reinvent a common wheel.

Kevin

 

 

Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 02 February 2004 at 2:07pm
Do a On Error Resume Next at the top of the page. Below that do a simple query i.e. SELECT * FROM yourtable. Under that put something like this:

If err.Number <> 0 Then
'Send a SMS
End if
Back to Top
kevinhann View Drop Down
Newbie
Newbie


Joined: 02 February 2004
Location: United Kingdom
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote kevinhann Quote  Post ReplyReply Direct Link To This Post Posted: 02 February 2004 at 2:54pm

doooahhh Angry

I was thinking of something more sophisticated but of course you're right thats all I need to do. Works fine.

 

Back to Top
pmormr View Drop Down
Senior Member
Senior Member


Joined: 06 January 2003
Location: United States
Status: Offline
Points: 1479
Post Options Post Options   Thanks (0) Thanks(0)   Quote pmormr Quote  Post ReplyReply Direct Link To This Post Posted: 03 February 2004 at 6:52pm
it's cool... we all have those days where we are braindead... one day i tried to spell four (the number) 4our
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.