"John" <john.xu@bestbuy.com> wrote in message
news:046801c357a3$dde453c0$a301280a@phx.gbl...
> I want to check if a database server is listening for
> connection before to connect to this database server. I
> heard that Weblogic comes with a class called
> java.util.dbping which does this. However, I am not sure
> whether other lagnuages have a similar one. To make it
> short, I am looking for an idea instead of tied to any
> programming language.
>
> I know I can do this by going to socket lever programming
> using tcp protocol so I can check if a specific port in a
> giving host to see if it is open to listen. Does someone
> know if a database server, like SQL 2000 server will echo
> anything to a client that sent a message or there is a
> specification on this purpose? The key is, I don't want
> open any connection before I know if the database is
> available or alive. So how can I check a database
> availability?
>
>
> Thanks in advance.
>
> John