Re: DBD::Sybase and packet sizes

From: Michael Peppler (mpeppler_at_peppler.org)
Date: 03/16/04

  • Next message: Veera Prasad: "cvs update on win32 hungs ..." 
    To: matthew.persico@verizon.net
Date: Tue, 16 Mar 2004 06:33:56 -0800

    On Tue, 2004-03-16 at 05:57, Michael Peppler wrote:
    > On Mon, 2004-03-15 at 18:41, Matthew O. Persico wrote:
    > > On Mon, 15 Mar 2004 17:58:42 -0800, Michael Peppler wrote:
    > > >On Mon, 2004-03-15 at 17:28, Matthew O. Persico wrote:

    > > >>Question 1: Now, according to what I've read, if you pass a CTlib
    > > >>app a value for packetsize that is too high, the connection will
    > > >>successfully negotiate a good value. Since DBD::Sybase uses CTlib
    > > >>under the covers, I suspect that I can throw 4096 into the DBI
    > > >>connection string with no ill effects, even if the max allowed by
    > > >>the server is less. Ditto for a straight CTlib app. True or false?
    > > >
    > > >Not quite - at least not during my quick tests involving OpenClient
    > > >12.5.1.
    > > >
    > > >Both DBlib and CTlib logins fail if you set the packet size larger
    > > >than the max allowed.
    > > >
    > > >The error message is:
    > > >
    > > >4024 10 2 0 luthien The packet size (4096) specified at login time
    > > >is illegal. Legal values are between 512 and 2048.
    > > >
    > > >and is the same for both Client Library and DB-Library apps.

    It turns out that this is an ASE 12.5.1 peculiarity (I don't know yet if
    it's a bug or not).

    When connecting to an 11.0.3.3 server the CTlib app properly negotiates
    the packet size down to what is supported by the server, but neither
    12.5.1 nor 12.5.0.3 do that (at least on my linux copy here).

    Michael 

    -- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.peppler.org/resume.html
  • Next message: Veera Prasad: "cvs update on win32 hungs ..."