FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

Hi,

coincidentally, I've been working on the same issue (client pid not
appearing in sysprocesses for SQL server)

I've got a new version of tds7 send_login() with this issue (and many
others) sorted out.

I've managed to decipher and deconstruct nearly all of the login packet,
such that there is no "magic" left in this function!

I'll submit my version later today....


Bill

> -----Original Message-----
> From: ZIGLIO Frediano [SMTP:Frediano.Ziglio AT vodafoneomnitel.it]
> Sent: 01 April 2003 10:40
> To:   'FreeTDS Development Group'
> Subject:      RE: [freetds] Misc fixes
> 
> > 
> > On Tue, 1 Apr 2003, ZIGLIO Frediano wrote:
> > 
> > > > pid.diff sends correct process ids /w TDS 7+.
> > > > crt.diff adds MS runtime bonds/memory accounting for 
> > debug versions.
> > 
> > > Hi Peter!
> > > Thanks for all your work.
> > > pid patch seem bad; you should send a 4 byte client version 
> > (I'm not sure
> > > this is client version...) and than a 4 byte pid.
> > > I'll apply crt.diff (I had to modify it, this patch work only on ms
> > > compiler...)
> > 
> > I think the tds header is wrong and pid comes first.  If you run
> > sqlprofiler client id's show up in the billions.  
> > Experimentally the first
> > byte in the comment for pid was actually the last byte and 
> > three back is
> > the actual start of the pid field.  With my change pids show up
> > correctly in profiler.
> > 
> > Have Fun!
> > Peter
> 
> You are right !!
> 
> 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."
> 
> =================================
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds