Steve-
do a
$returnCode = system("tnsping".hostname);
read the returnCode for "ok" to determine listener is up
HTH
Martin Gainty
DBA/Programming Instructor
Meet the new Boss..Same as the Old Boss - Roger Daltrey
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender. This transmission is of a confidential nature and Sender does not
endorse distribution to any party other than intended recipient. Sender does
not necessarily endorse content contained within this transmission.
> Subject: Checking status of a DB handle
> Date: Fri, 7 Nov 2008 14:29:48 -0500
> From: [EMAIL PROTECTED]
> To: [email protected]
>
> I'd like to be able to check to see if a DB connection is still alive,
> without sending a command to the connected server. To make it more
> complicated, I'd like it to work with Sybase, MySQL, and, if possible,
> Oracle.
>
> Is there any way to do this?
>
>
> Steve Wechsler | [EMAIL PROTECTED]
> Sybase/SQL Server/MySQL Database Administrator
> 212-846-5683
>
> MTV Networks
>
>
_________________________________________________________________
See how Windows® connects the people, information, and fun that are part of
your life
http://clk.atdmt.com/MRT/go/119463819/direct/01/
