set textsize 1048576 fails

Brian Bruns camber at ais.org
Tue Oct 30 14:08:30 EST 2001


BTW James,

I've checked in some changes for this...see if they work ;-)

Brian

On Tue, 30 Oct 2001, Brian Bruns wrote:

>
> <rant> The problem with ctlib is that it often doesn't reflect what
> happens at the protocol level like dblib does </rant>
>
> Not that the protocol and API necessarily have to agree, but it seems a
> bit pointless.
>
> Thanks Michael.
>
> Brian
>
> On Tue, 30 Oct 2001, Michael Peppler wrote:
>
> > I just ran this with the Sybase libs:
> >
> > use Sybase::CTlib;
> >
> > my $dbh = new Sybase::CTlib 'sa', '';
> >
> > $dbh->ct_execute("set textsize 10000");
> > while(($ret = $dbh->ct_results($restype)) == CS_SUCCEED) {
> >     print "$ret, $restype\n";
> > }
> >
> > I get:
> >
> > troll (7:23AM):144 > perl ~/tmp/res.pl
> > 1, 4047
> > 1, 4046
> >
> > So that's two calls with ct_results() returning CS_SUCCEED, with
> > CS_CMD_SUCCEED and CS_CMD_DONE returned for the restype value.
> >
> > Michael
> >
> >
> > Brian Bruns writes:
> >  > Ok,
> >  >
> >  > found out what is going on...whether it is correct (from a freetds
> >  > standpoint) is another question.
> >  >
> >  > Whenever a query is issued that returns no results, ct_results() returns
> >  > CS_END_RESULTS on first invocation. CS_END_RESULTS != CS_SUCCEED, so PHP
> >  > gives up and disconnects.
> >  >
> >  > Question is, should the first invocation return CS_END_RESULTS, or should
> >  > it return CS_SUCCEED the first time, follow subsequently by
> >  > CS_END_RESULTS....
> >  >
> >  > Brian
> >  >
> >  > On Tue, 30 Oct 2001, James Cameron wrote:
> >  >
> >  > > Brian Bruns wrote:
> >  > > > Ok, so nothing to do with set textsize exactly then...out of curiousity
> >  > > > (again), you're using sybase-ct, can you configure --with-sybase instead
> >  > > > and see if the problem remains?
> >  > >
> >  > > Trying.  Failing ... I've gotta first understand the Debian build
> >  > > scripts; I thought it would be a simple task to change the configure in
> >  > > PHP's debian/rules file in the package source directory, but that has
> >  > > led to a php4-sybase package with no actual shared library in it.  Not
> >  > > surprisingly the result is sybase_connect() undefined.
> >  > >
> >  > >
> >  >
> >  >
> >  > ---
> >  > You are currently subscribed to freetds as: [mpeppler at peppler.org]
> >  > To unsubscribe, forward this message to $subst('Email.Unsub')
> >
> >
>
>
> ---
> You are currently subscribed to freetds as: [camber at ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>




More information about the FreeTDS mailing list