Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: RE: The late SybTools and MSSQL
Date: May 21 2004 2:46PM

On Fri, 2004-05-21 at 10:59, Owen, Robert wrote:

> We now have freetds, DBlib and perl talking to MSSQL.   Minor celebration.


> I figure the less I change the less I need to test...   So, if you
> have no objection, I'll change to talk DBlib.

Be my guest :-)


> -----Original Message-----
> From: []On
> Behalf Of Michael Peppler
> Sent: 20 May 2004 18:50
> To: Sybperl-L Mailing List
> Subject: Re: The late SybTools and MSSQL
> On Thu, 2004-05-20 at 17:59, Owen, Robert wrote:
> > Apologies if this has been posted before but...
> > 
> > I have a pile of legacy perl code that runs on AIX against a Sybase
> > database.    It uses version 1.3.   I'm far too lazy to
> > touch it!   
> > 
> > Naturally, it now must run against MSSQL server on AIX.
> > 
> > Now I believe that DBI::Sybase can talk to MSSQL however SybTools uses
> > CTlib.   BooHoo:(    But the code only uses ArrayOfHash, ExecSql and
> > HashOfScalar from SybTools.    Should I / could I hack SybTools to use
> > BDlib instead??
> Actually, DBD::Sybase and Sybase::CTlib use the same underlying
> interface. To get them to talk to MS-SQL you have to use the FreeTDS
> libraries instead of the Sybase libs (see for
> details).
> I would suggest that you convert your scripts to use the Sybase::Simple
> module, which is the evolution of SybTools, and which is still actively
> developed. 
> And modifying Sybase::Simple to work on top of DBD::Sybase (or
> Sybase::DBlib) should be pretty straightforward if you needed to do
> that.
> Michael
Michael Peppler                              Data Migrations, Inc.             
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions -