Skip to Content.
Sympa Menu

freetds - RE: [freetds] Named Instances of MS SQL Server 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Named Instances of MS SQL Server 2000
  • Date: Fri, 7 Feb 2003 12:20:11 +0100

>
> To answer your question, named pipes.
>
> NETSDK is the MSDE (Microsoft SQL Server Desktop Engine)
> sample database
> that comes with .NET Framework.
>
> Here is what I got when I ran the program:
>
> Sent: "DANPC\\NETSDK"
>

How this data is sent ? To what server ? I think DANPC, UDP port 1434 ...
but data sound weird to me...

> Returned RawString with length of 121 octet bytes:
> .v.ServerName;DANPC;
> InstanceName;NETSDK;
> IsClustered;No;Versi
> on;8.00.194;tcp;1335
> ;np;\\DANPC\pipe\MSS
> QL$NETSDK\sql\query;
> ;
>
> ASCII Hex:
> 05

Information type ? server information ?

> 76 00

Information length (bytes)

> 53 65 72 76 65 72 4e 61 6d 65 3b 44 41 4e 50 43 3b
> 49 6e 73 74 61 6e 63 65 4e 61 6d 65 3b 4e 45 54 53 44 4b 3b
> 49 73 43 6c 75 73 74 65 72 65 64 3b 4e 6f 3b 56 65 72 73 69
> 6f 6e 3b 38 2e 30 30 2e 31 39 34 3b 74 63 70 3b 31 33 33 35
> 3b 6e 70 3b 5c 5c 44 41 4e 50 43 5c 70 69 70 65 5c 4d 53 53
> 51 4c 24 4e 45 54 53 44 4b 5c 73 71 6c 5c 71 75 65 72 79 3b
> 3b
>

ASCII information (UTF8, Latin1) ???

> Based on the above:
> ServerName = DANPC
> InstanceName = NETSDK
> IsClustered = No
> Version = 8.00.194
> tcp = 1335
> np = \\DANPC\pipe\MSSQL$NETSDK\sql\query
>

Request in one byte 02 , correct ? Port 1434, UDP.

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================




Archive powered by MHonArc 2.6.24.

Top of Page