|
|
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
|
