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: Garrett Goebel <garrett AT scriptpro.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Freetds and linux
  • Date: Tue, 11 Mar 2003 11:11:54 -0600

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




Archive powered by MHonArc 2.6.24.

Top of Page