Skip to Content.
Sympa Menu

freetds - Re: [freetds] dbcanquery() with pdo_dblib

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Adam Baratz <adam.baratz AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] dbcanquery() with pdo_dblib
  • Date: Mon, 20 Jun 2016 17:07:46 -0400

Thanks for the fast fix!

On Sat, Jun 18, 2016 at 4:26 PM, Frediano Ziglio <freddy77 AT gmail.com> wrote:

> Fixed.
>
> Frediano
>
> 2016-06-17 16:22 GMT+01:00 Adam Baratz <adam.baratz AT gmail.com>:
> > Thanks, see attached. I [redacted] the auth transmission.
> >
> > On Fri, Jun 17, 2016 at 4:16 AM, Thompson, William <
> bill.d.thompson AT baml.com
> >> wrote:
> >
> >> Hi Adam,
> >>
> >> I don't think you've misunderstood what dbcanquery is supposed to do.
> The
> >> Sybase documentation says that it is equivalent to calling dbnextrow
> until
> >> it reurns NO_MORE_ROWS, which is pretty much what you've replicated.
> >> So it looks like our implementation of dbcanquery() isn't exactly the
> same
> >> as doing that...
> >>
> >> It's difficult to see what might be happening without a debug log
> >> Can you run your test of dbcanquery() with TDSDUMP logging set? And then
> >> post with the log attached?
> >> See http://www.freetds.org/userguide/logging.htm
> >>
> >> Cheers,
> >>
> >> Bill
> >>
> >>
> >> -----Original Message-----
> >> From: FreeTDS [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
> >> Adam Baratz
> >> Sent: 16 June 2016 17:19
> >> To: freetds AT lists.ibiblio.org
> >> Subject: [freetds] dbcanquery() with pdo_dblib
> >>
> >> Hi,
> >>
> >> I'm looking at fixing this bug with the PHP pdo_dblib extension:
> >> https://bugs.php.net/bug.php?id=67130
> >>
> >> I have it built to use FreeTDS to communicate with MSSQL.
> >>
> >> My understanding from the docs is that dbcanquery() does what's needed
> >> here. Basically, it should be called before using dbresults() to get the
> >> next rowset[1]. However, that doesn't seem to resolve the issue. The
> call
> >> succeeds, but the call to dbresults() will then fail. What I've found
> works
> >> is fetching the rows manually:
> >>
> >> RETCODE ret = SUCCESS;
> >>
> >> while (ret == SUCCESS) {
> >> ret = dbnextrow(H->link);
> >> }
> >>
> >> I don't want to do anything with these rows, so I'd rather not do this.
> Am
> >> I missing something basic about how dbcanquery() is supposed to be used?
> >>
> >> Thanks,
> >> Adam
> >>
> >> ---
> >> [1]
> >>
> >>
> https://github.com/php/php-src/blob/aed42496534fe54c5c0ce64fe0ca5c9d801d6161/ext/pdo_dblib/dblib_stmt.c#L144
> >> _______________________________________________
> >> FreeTDS mailing list
> >> FreeTDS AT lists.ibiblio.org
> >> http://lists.ibiblio.org/mailman/listinfo/freetds
> >>
> >> ----------------------------------------------------------------------
> >> This message, and any attachments, is for the intended recipient(s)
> only,
> >> may contain information that is privileged, confidential and/or
> proprietary
> >> and subject to important terms and conditions available at
> >> http://www.bankofamerica.com/emaildisclaimer. If you are not the
> >> intended recipient, please delete this message.
> >> _______________________________________________
> >> FreeTDS mailing list
> >> FreeTDS AT lists.ibiblio.org
> >> http://lists.ibiblio.org/mailman/listinfo/freetds
> >>
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page