FreeTDS Development Group

["Robb Hill" <rhill AT capitoladvantage.com>]

Hi,

I am hoping someone can point me in the right direction.  I need to create a
utility to perform a protocol level ping for SQL Server 7 and 2000 in Perl.

The SQL 2000 was no big deal because of the udp ping that can be used to
query the server on port 1434.

However it does not appear that this is possible on SQL 7.

I have been reviewing the source code for hints on where I could find a
'ping' type of request that can be sent to SQL 7.  Any ideas?

I do need to do this in perl on the socket level and not using DBI.
(Constraints of the production environment.)  So I guess what I really need
to understand is the protocol on a level where I can send a request to a
server and if I get something back that looks 'good' then I know all is well
with the server.

Any pointers to places in the freetds code or docs where I can find this
info?

Thanks,
Robb