From: 
        Héctor Linaje <hector@actional.com>
                                                                                          10:23 AM

 Subject: 
        Re: DBD:Sybase running on Red Hat 6.0 and Mandrake 8.0 to connet to SQL Server 7.0.
     To: 
        WHIRLYCOTT <phil@whirlycott.com>




Yep, no problem, and I found out that the (potato) Debian distribution 
includes the freetds libraries already, so anybody that has that Linux will 
be able to connect to MSQL7.0  and their previous versions (on MSQL2000 I 
think they changed the protocol) just by adding the DBI and DBD:Sybase perl 
modules.

Saludos,
__
hle.

On Thursday 23 August 2001 10:07, you wrote:
> Thanks Hector - I'd like to add your email to my page, if you don't
> mind.
>
> Let me know.
>
> Glad to have helped!
>
> phil.
>
> Héctor Linaje wrote:
> > Hi Phil,
> >
> > Your page helped me to realize about some coding errors that I had for my
> > little program, thanks for giving yourself some time to write your web
> > page!
> >
> > So, I'm writing you in response for the section: Note about Microsoft SQL
> > Server which I got working from 2 Linux boxes:
> >
> > I. Perl 5.
> > 1. Perl 5, apearently any version after 5 is good I tried: 5.005_03 and
> > 5.6.0 and I didn't have any poblem.
> >
> > II. DBI module
> >
> > From: http://search.cpan.org/search?module=DBI
> >
> > 2. You need it to install the DBD:Sybase module as you mentioned on your
> > page, I installed DBI 1.19, no problem at all, the usual: perl
> > makefile.PL, make, make install.
> >
> > III. FreeTDS
> >
> > From: http://www.freetds.org/download.html
> >
> > 3. As you can see from their web page TDS(Tabular DataStream) is a common
> > protocol between Sybase and Microsoft for client to server connections.
> >
> > 1. ./configure
> > I downloaded version 0.51 and did a plain configure. Check
> > http://www.hklc.com/infocenter/301.html where they recommend you to use
> > certain parameter values and to rename some files before running
> > configure, I didn't need this, by default caught the tds 4.2 version
> > protocol.
> >
> > 2. make
> >
> > 3. make install
> >
> > 4. modify /usr/local/freetds/interfaces, example:
> >
> >  server-name
> >         query tcp tds4.2 x.x.x.x 1433
> >
> >  Where tds4.2 is the protocol used by SQLServer, x.x.x.x is your numeric
> > ip for the SQLServer and 1433 is the MS SQL 7.0 TCP port by default.
> >
> > IV. DBD:Sybase
> >
> > This is where I got some problems I had to download not the latest
> > version but the previous one, I continuing had problems with DBD:Sybase
> > 0.93 on the previoulsy stated platforms.
> >
> > DBD:Sybase 0.91
> >
> > From: http://www.mbay.net/~mpeppler/
> >
> > 1. Edit the CONFIG file as follows:
> >
> > SYBASE=/usr/local/freetds
> > EXTRA_LIBS=-linsck
> > DBI_INCLUDE=/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI
> > as for the last one you probably don't need to include it, the
> > Makefile.PL will catch it for you, if DBI was properly installed.
> >
> > 2. perl Makefile.PL
> > 3. make
> > 4. make install
> >
> > Next thing I tried was Program 1 sample adding the database name at:
> >
> > my ($data_source)       = "dbi:Sybase:database=database_name";
> >
> > et voila!.
> >
> > Between you, Brian Bruns (who started the TDS project) and Michael
> > Pepplers (who wrote the DBD:Sybase) just saved us $2000!. We were looking
> > at other options to install ODBC drivers on Linux and those third parties
> > were selling their drivers kind of expensive.
> >
> > I just got this solution up & running a few minutes ago, but a simple
> > request to some tables is working as wanted.
> >
> > Gracias y saludos,
> >
> > --
> > Greetings, Héctor Linaje
> >                 IT Department/UNIX Systems
> >                 Actional Canada Corporation.