PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: DBD::Sybase and packet sizes
Date: Mar 16 2004 2:33PM

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