Skip to Content.
Sympa Menu

freetds - Re: How to tell server type?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: How to tell server type?
  • Date: Mon, 21 Jan 2002 14:47:50 -0500 (EST)



I'm going to concur with Michael here. The product name in the ack token
is not real reliable (it is 'sql server' for both Sybase and MS) and the
four product version octets (11.9.2 -> 0x0b 0x09 0x02 0x00) will someday
overlap I'm sure. Besides MS has decided that service packs aren't
important enough to report, so the only useful thing here is all but
useless.

Brian

On Mon, 21 Jan 2002, Michael Peppler wrote:

> Clive George writes:
> > How can I find out what sort of server I'm connected to? (ie is it Sybase
> > or MS?)
>
> Your best bet is probably to select @@version...
>
> Michael
>





Archive powered by MHonArc 2.6.24.

Top of Page