[freetds] The old MSSQL from Linux...

Bort, Paul pbort at tmwsystems.com
Thu Jan 30 12:43:52 EST 2003


I saw something somewhere (FreeTDS release notes? DBD::Sybase?) that
placeholders just don't work. Other than that, it works.

> -----Original Message-----
> From: Poulson, Shawn [mailto:shawn.poulson at sap.com]
> Sent: Thursday, January 30, 2003 12:28 PM
> To: 'freetds at lists.ibiblio.org'
> Subject: RE: [freetds] The old MSSQL from Linux...
> 
> 
> 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?
> 
> > -----Original Message-----
> > From: Craig Davison [mailto:cd at securityfocus.com]
> > Sent: Wednesday, January 29, 2003 4:24 PM
> > To: freetds at lists.ibiblio.org
> > Subject: Re: [freetds] The old MSSQL from Linux...
> > 
> > 
> > On Wed, Jan 29, 2003 at 10:04:57PM +0100, Poulson, Shawn wrote:
> > > Has anyone had luck with this?
> > 
> > Here's how I did it:
> > 
> > - Installed FreeTDS 0.60 RPMs (freetds-0.60-1 and 
> > freetds-devel-0.60-1)
> > 
> > - Edited /etc/freetds/freetds.conf to include a server on my 
> > network (for 
> > the DBD::Sybase make test). There are examples in that file.
> > 
> > - Created symlinks to the freetds include files:
> >   cd /usr/include
> >   find freetds -name \*.h -exec ln -s {} \;
> > 
> > - Downloaded DBD::Sybase 0.91. This is not the latest version 
> > but it seems 
> > to work very well. (*)
> > 
> > - Set SYBASE:
> >   export SYBASE=/usr
> > 
> > - Built DBD::Sybase, and specified the server I had in my 
> > /etc/freetds/freetds.conf as a test server. Note that make 
> > test will not 
> > succeed 100%, but it will get close (95% or so):
> >   perl Makefile.PL
> >   make
> >   make test
> >   make install
> > 
> > Good luck!
> > 
> > (*) DBD::Sybase 0.95, the latest, requires some small code 
> > changes to work 
> > with FreeTDS 0.60. Apparently it will just work when 0.61 
> is released.
> > 
> > -- 
> > Craig Davison
> > Symantec Corporation
> > +1 (403) 213-3939 ext. 228
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS at lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> > 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 



More information about the FreeTDS mailing list