Skip to Content.
Sympa Menu

freetds - Re: [freetds] stop the presses....0.61rc2

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] stop the presses....0.61rc2
  • Date: Sun, 23 Feb 2003 08:32:57 -0500 (EST)


Here is Sybase ASA 5.5 using OSG (OpenServer Gateway). The spid entry is
'0'. IIRC, sybase ASE does the exact same thing, so this is an MS only
thing.

Received header @ 2003-02-21 18:49:35.436953
0000 0f 01 00 2d 00 00 01 00 |...-....|

Now, when doing a

exec server2.db1..myproc

then your local server connects to server2 and called the stored proc in
your place. In the instance that two people make a stored procedure call
like this, it multiplexes the commands over a single tcp session using (I
believe) the two byte spid in the header to keep things straight. So,
it's there in sybase, just turned off most of the time we are looking
(client to server).

Anyway, it doesn't buy us much because we still have to issue select
@@spid in most instances.

Speaking of which though, this week I was looking at the Sybase ASE 12.5
migration guide. One of the features there was they upped the max number
of users from 2^16 to something bigger. So, it is likely that by setting
the right capabilities under the TDS 5.0 login packet that select @@spid
may have broke anyway. This is all unconfirmed conjecture of course.

On 23 Feb 2003, Frediano Ziglio wrote:

> Il sab, 2003-02-22 alle 20:36, Brian Bruns ha scritto:
> > I believe that is used for rpc (server to server) connections right?
> > Sybase has those zeroed in client-to-server streams i believe. Perhaps,
> > MS
> > has them on all the time?
> >
> > Brian
> >
>
> I tested today with a mssql2k server.
> These are the results of 3 connect to same server (same using TDS7 and TDS8)
>




Archive powered by MHonArc 2.6.24.

Top of Page