FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

On Wed, 16 Jul 2003 18:37:19 -0400, "Ben Vaughn"
<bvaughn AT BlackbirdTech.com> wrote:
> Interesting...What does this line of the TDSDUMP file specify?  That's
> where I can see TDS submitting that info to the server.

Indeed you do.  FreeTDS sent "appnameappnamea" in the app_name field of
the login packet (see doc/tds.html for explication).  My breakdown of your
packet follows.  What I don't understand is, where FreeTDS decides to
populate the app_name field with your servername as found in freetds.conf.
 

--jkl

Header
0000 02 00 02 00 00 00 00 00-

   8   CHAR[30]    host_name
     6d 61 6e 61 67 65 2e 70 |........ manage.p|
0010 69 63 6b 65 74 2d 66 65-6e 63 65 2e 6f 72 67 00 |icket-fe nce.org.|
0020 00 00 00 00 00 00 

  38   INT8        host_name_length
     17 
     
  39   CHAR[30]    user_name
     69-64 73 6d 64 63 00 00 00 |.......u nameu...|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 

  69   INT8        user_name_length
     06 
     
  70   CHAR[30]    password
     43 31-73 43 30 43 31 73 43 30 |......pw pwpwpwpw|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 

 100   INT8        password_length
     0a 
     
 101   CHAR[30]    host_process
     33 37 38-37 36 00 00 00 00 00 00 |.....378 76......|
0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0080 00 00 00 

 131   INT8        host_process_length
     05 
     
 132   ?           magic1[6]          /* mystery stuff */
     03 01 06 0a-09 01 
     
 138   INT8        bulk_copy 
     00 
     
 139   ?           magic2[9]          /* mystery stuff */
     00 00 00 00 00 |........ ........|
0090 00 00 00 00 

 148   CHAR[30]    app_name
     73 71 6c 63-6f 72 65 64 62 73 65 72 |....appn ameappna|
00a0 76 65 72 00 00 00 00 00-00 00 00 00 00 00 00 00 |mea..... ........|
00b0 00 00 

 178   INT8        app_name_length
     0f 
     
 179   CHAR[30]    server_name
     69 64 73 6d 64-63 00 00 00 00 00 00 00 |...uname u.......|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 

 209   INT8        server_name_length
     06