FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

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