FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

On Tue, 2003-03-11 at 09:11, Garrett Goebel wrote:
> 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?

Yes - it's only a question of FreeTDS supporting the API. From what I've
been reading here there have been huge steps in that direction...

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler AT peppler.org                 http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.mbay.net/~mpeppler/resume.html