Skip to Content.
Sympa Menu

freetds - RE: [freetds] Freetds and linux

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Freetds and linux
  • Date: 11 Mar 2003 09:30:32 -0800

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




Archive powered by MHonArc 2.6.24.

Top of Page