Skip to Content.
Sympa Menu

freetds - RE: [freetds] The old MSSQL from Linux...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] The old MSSQL from Linux...
  • Date: 30 Jan 2003 21:14:36 +0100

Il gio, 2003-01-30 alle 19:18, Lowden, James K ha scritto:
> > From: Poulson, Shawn [mailto:shawn.poulson AT sap.com]
> > Sent: January 30, 2003 12:28 PM
> >
> > Thanks for the tips. I got DBD::Sybase 0.91 and it seems to
> > be more successful than 0.95. I was able to get simple
> > queries to work.
> >
> > However I can't get placeholders to work. DBI->stderr says I
> > need to use TDS 5.0. But I specified tds version = 7.0 in
> > freetds.conf. I even tried tdsLevel=CS_TDS_50 in the dbi:
> > connection string. Any ideas?
>
> Shawn,
>
> IIRC, placeholders are only partly done in ct-lib, which is what DBD::Sybase
> uses. If they work at all, you definitely would need a recent snapshot of
> FreeTDS, and DBD::Sybase 0.95.
>
> I don't find any thing in ChangeLog or TODO, but ct_send_dyn() is more than
> a mere stub. There's no unit test, leading me to think Freddy (?) isn't
> done with it.
>

libtds have full support for server placeholders but only ODBC libraries
use it. Also code is still in developing (I had some problem with text
fields and other)...

> The DBI error message regarding TDS 5.0 isn't accurate. It should say you
> can't use placeholders with TDS 4.2. You absolutely cannot use TDS 5.0 with
> Microsoft servers (well, you *can*, if you install Microsoft's patch, on
> some servers, but whether that would support placeholders is anyone's
> guess). We have some placeholder functionality working, and *only* on TDS
> 7.0+.
>

Also work on TDS5. Not on TDS4.2 (ODBC use a manually crafted method)

> You might want to check the ML archives since November.
>
> An alternative is DBD::ODBC, since placeholders are somewhat functional in
> our ODBC driver. But that has other drawbacks.
>
> We should update the TODO to reflect the status accurately.
>

I think so...

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page