FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> 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.  

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+.  

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.  

--jkl


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.