PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
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 SybTools.pm to talk DBlib.

Be my guest :-)

Michael


> -----Original Message-----
> From: owner-sybperl-l@peppler.org [mailto:owner-sybperl-l@peppler.org]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 SybTools.pm 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 http://www.freetds.org/ 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.
mpeppler@peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html