FreeTDS Development Group

[Garrett Goebel <garrett AT scriptpro.com>]

From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
> > From: Peter Milburn [mailto:peterm AT sportodds.com]
> > 
> > We are currently using freetds with the sybase drivers to 
> > connect to MS SQL
> > with php. We are now trying to do the same in perl. I have 
> > tried  a few ways, but have had no luck. 
> 
> Best results with Perl would be from the FreeTDS 0.61 release
> and DBD::Sybase 0.95, using ct-lib.  That combination will 
> connect to Microsoft databases, too.  

on perl-DBI-Dev, Michael Peppler wrote:
> 
> However, due to FreeTDS not implementing all of the Sybase
> Client Library API, and to the fact that not all of the TDS
> protocol supported by MS-SQL has been decoded there are a
> number of things in DBD::Sybase that fail when used with
> FreeTDS. 

Limiting myself to just MSSQL oddities documented in DBD::Sybase:
o  you're required to use TDS 4.2 (ascii only)
o  no support for placeholders
o  no inout params
o  working /w blobs requires DBD-specific options

Aren't these inherent limitations of using ct-lib to connect to MSSQL? Will
there ever be a DBD::Sybase that allows you to use placeholders, etc. with
MSSQL?

And as DBD::FreeTDS appears to be dormant, I would think DBD::ODBC would be
preferred...

--
Garrett Goebel
IS Development Specialist

ScriptPro                  irect: 913.403.5261
5828 Reeds Road            Main:  913.384.1008
Mission, KS 66202          Fax:   913.384.2180
www.scriptpro.com          garrett at scriptpro dot com