FreeTDS Development Group

["Shama Dhume" <shama_dhume AT persistent.co.in>]

Hi,

Could you give me any idea as to where(in which file) the server information
is stored?(for e.g. For MS SQL Server, the string "Microsoft SQL Server" is
stored on the server(MS SQL Server 2000)).

UCS-2 Unicode uses 2 bytes for every character.
I need to find out how exactly the sting "Microsoft SQL Server" is stored on
the server so as to check with the Unicode representation of it. What I mean
is, I want to know the file where this information is stored.

Any inputs/references which answer this query would be appreciated.

Thanks,
Shama


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of ZIGLIO, Frediano,
VF-IT
Sent: Monday, March 26, 2007 5:31 PM
To: FreeTDS Development Group
Subject: Re: [freetds] MS SQL Query


> 
> Hi,
> 
>  
> 
>  
> 
> I wanted to know about "Login Acknowledgement token" which comes in a
> response to a "Login" packet for TDS(protocol version 8) in 
> case of MS SQL
> Server  2000.
> 
> The question is, in the trace I see Server Name as "Microsoft 
> SQL Server".
> But there are  four extra unknown bytes(all zeroe's)  that 
> come after the
> Server Name.
> 
> I wanted to know how exactly the encoding is done for storing 
> Server Name.
>     
> 
> Any inputs/references which answer this query would be appreciated.
> 
>  
> 
> Thanks,
> 
> Shama
> 

I think is some kind of alignment. Yes, it's odd but you will note that
length is 0x16 (22) and string is "Microsoft SQL Server\0\0" (which is
22 characters). If I remember encoding for server version is smothing
like major minor build_high build_low (4 bytes).

freddy77

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds