Skip to Content.
Sympa Menu

freetds - Re: tdsping?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Brian Bruns" <camber AT ais.org>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: tdsping?
  • Date: Mon, 15 Jul 2002 12:29:43 -0400


Sybase's ping utility (used to be dbping, then it was integrated into
dsedit) just opens the tcp post and if it gets a clean connection
succeeds, if it gets a timeout or connection refused then it fails. A
technique I've used in the past is to send an invalid login to make sure
what's on the other end is a functioning sql server. But, you may not want
a bunch or bad logins showing up in your logs. ;-)

You got any details on the udp thing for SQL 2000?

Brian

> 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



  • tdsping?, Robb Hill, 07/15/2002
    • <Possible follow-up(s)>
    • Re: tdsping?, Brian Bruns, 07/15/2002
    • Re: tdsping?, Robb Hill, 07/15/2002
    • Re: tdsping?, Brian Bruns, 07/15/2002

Archive powered by MHonArc 2.6.24.

Top of Page