Re: Server Mode from Windows 95

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Fri, 17 Apr 1998 07:28:54 +0200
Message-ID: <6h6p5p$fpk$1@hermes.is.co.za>

vivekus_at_hotmail.com wrote in message <6h5dit$kao$1_at_nnrp1.dejanews.com>...
>How do I find the state/mode of the database server from Windows 95? I
need
>to know if a particular database is up, down or in any other state/mode. Is
>there any 'C' function, API or anything else that I can plug into my 'C'
code
>(on Windows 95) and get the state of the server? If yes, what are the
>parameters and the return values?

Simply open a connection to the database server and catch any exceptions that are raised. Interrogate the exception to determine if

- the listener is not running
- the TNS specified could not be found
- the database is down
- the database is busy going down
- the database is in exclusive mode'

etc. etc.

Why make things more complex than they already are? :-)

regards,
Billy Received on Fri Apr 17 1998 - 00:28:54 CDT