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. [EMAIL PROTECTED] 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
