FreeTDS Development Group

[dblist <dblist AT fingerlust.wtfs.net>]

Eric,

Thank you so much for the info.  :-)  You mentioned some extensive notes
and sample perl scripts... If you have them handy and if it's not too much
trouble, I'd love to take a look if you want to send them to me off list.

I did run into a slight problem when doing a 'make test' on the Sybase
module after successfully installing the other components.  Here's the
output I get:

$ make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/lib/perl5/5.00503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use
Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/autocommit........dubious
        Test returned status 0 (wstat 139, 0x8b)
Undefined subroutine &Test::Harness::WCOREDUMP called at
/usr/lib/perl5/5.00503/Test/Harness.pm line 288.
make: *** [test_dynamic] Error 255

Have you run into this before?  Any suggestions?

Again, thank you for the help, I'll definitely be checking out some of the
software you recommended (once I get everything working, of course).  :-)

- John J. Reilly
- dblist AT fingerlust.wtfs.net


On Mon, 9 Jul 2001, Eric Deutsch wrote:

>
> Hi John, I run a similar setup, except with Red Hat 7.0 with great results.
> I have some more extensive notes if you need more, but the best solution
> I've found is:
>  - Install DBI-1.15.tar.gz from CPAN
>  - Install Data-ShowTable-3.3.tar.gz from CPAN (optional)
>  - Install freetds-0.52.tgz from freetds.org
>    (I just do `./configure --with-tdsver=7.0` and `make`, `make install`)
>  - Install DBD-Sybase-0.91.tar.gz from CPAN
>
> (The version numbers are just the ones I used; later ones are fine)
>
> Get perl modules from http://www.perl.com/CPAN/modules/by-module or your
> other favorite method. Install perl modules with:
>   perl Makefile.PL
>   make
>   make test
>   make install
> Before installing DBD-Sybase, do:
>   setenv SYBASE /usr/local/freetds
>
> I can send you a sample little Perl program that you can use to test things.
>
> Other software I've found very useful with Linux + MS SQL Server 2000:
>
> Even if you don't program in Java, I *HIGHLY* recommend the following:
> - Sun Java JDK 1.3.1 Red Hat RPM from
> http://java.sun.com/j2se/1.3/download-linux.html
> - Java Transact-SQL Analyzer from
> http://sourceforge.net/projects/sqlanalyzer
>   Run with something like:
>     setenv PATH ${PATH}:/usr/java/jdk1.3.1/bin
>     java -jar tsa.jar
>
> For a good command line interface, get SQSH and compile after installing
> FreeTDS.
>
> If you want a GUI Perl/Tk tool for issuing queries and viewing results, a
> nice tool I've found is asSQL, also available on SourceForge.  I run a
> somewhat hacked version along with a slightly hacked version of
> Data-ShowTable-3.3 but I think it should mostly work as is available at
> SourceForge.  You do need to install Perl/Tk first, which may not be
> painless.
>
> One project that's always intrigued me was KSQL.  I've never been able to
> compile KSQL much less test against SQL Server.  Has anyone put there ever
> used KSQL successfully against SQL Server?
>
> Hope some of this helps,
> Eric
>
>
>
> > -----Original Message-----
> > From: bounce-freetds-127899 AT franklin.oit.unc.edu
> > [mailto:bounce-freetds-127899 AT franklin.oit.unc.edu]On Behalf Of John J.
> > Reilly
> > Sent: Monday, July 09, 2001 3:56 PM
> > To: TDS Development Group
> > Subject: [freetds] Installing FreeTDS, DBI, etc.

> >
> >
> > Hello all,
> >
> > I'm new to the list, so please be gentle. :-)
> >
> > I'm trying to connect to a Microsoft SQL Server 2000 database from a Linux
> > box using perl scripts.  I think I'd like to use FreeTDS and one of the
> > DBI modules to accomplish this.  I've been going around in circles for a
> > few days now trying to figure out exactly what software I need, and how to
> > install & configure it.  And to be honest, I'm getting more and more
> > befuddled with each README and FAQ that I read.  Needless to say, I'm
> > fairly new at database connectivity topics, but I am somewhat competent
> > with Linux, so if given good directions I'd be in decent shape.
> >
> > If anyone here would be willing to provide me with newbie-oriented
> > information on how to accomplish this from start to finish (or point me to
> > where this information could be found), I'd be eternally grateful.  :-)
> >
> > Once again, a rundown:
> >
> > Connecting to:
> >     Microsoft SQL Server 2000
> > From:
> >     Linux (redhat 6.2)
> > Using:
> >     FreeTDS, and perl DBI
> >
> > Thanks in advance for any help, and I apologize for my ignorance. :-)
> >
> > - John J. Reilly
> > - dblist AT fingerlust.wtfs.net
> >
> > ---
> > You are currently subscribed to freetds as: [edeutsch AT systemsbiology.org]
> > To unsubscribe, forward this message to
> > $subst('Email.Unsub')
> >
>
>
> ---
> You are currently subscribed to freetds as: [dblist AT fingerlust.wtfs.net]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>