Russell,
If you used the outline that I provided for you in earlier emails, then
you'll want to type the following command before you run, 'perl
Makefile.PL':
export SYBASE=/usr
However, if you did your own thing... well look at your FreeTDS install
source to determine where it installs it by default (/usr/local probably),
unless of course you declared your own prefix with you originally ran
configure on it (ie, './configure --prefix=/usr' ).
If you are not to sure where you put it, go back and read my directions.
It won't hurt anything to run the FreeTDS install again.
Karyn
-----Original Message-----
From: Russell Kroboth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 1:26 PM
To: 'Karyn Ulriksen'; [EMAIL PROTECTED]
Subject: RE: connecting perl to MS SQL on Linux
Ok, I was able to get FreeTDS installed and the FreeTDS driver, and can
connect successfully to my MS SQL database using tsql.. However, when
installing the DBD::Sybase Driver, it says I need to set the environment
variable export SYBASE=/usr/local/freetds ... However on my system , this
directory does not even exist. Any ideas?
Thanks!
> -----Original Message-----
> From: Karyn Ulriksen [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 2:22 PM
> To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
> Subject: RE: connecting perl to MS SQL on Linux
>
>
> Use the DBD::Sybase Driver... BUT!!! Don't use the current
> version (0.95),
> use the last version (0.94). I've been using FreeTDS for
> about the past two
> years. Works like a charm. Don't use ODBC, since it adds an
> unnecessary
> layer. FreeTDS speaks to the MS SQL natively.
>
> Karyn
>
>
> -----Original Message-----
> From: Russell Kroboth [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 11:04 AM
> To: [EMAIL PROTECTED]
> Subject: RE: connecting perl to MS SQL on Linux
>
>
>
> I think I just found a database driver, something called
> FreeTDS, which is billed as just that. I downloaded
> (www.freetds.org) and installed the rpm without error. But I
> still get the same error when trying to do the final step of
> installing the DBD::ODBC package. I wonder home I can make
> this link between my unixODBC driver manager and DBD::ODBC,
> which the Makefile.PL says I need to have...
>
> > > -----Original Message-----
> > > From: Tim Howell [mailto:[EMAIL PROTECTED]
> > > Sent: Monday, February 24, 2003 12:35 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: RE: connecting perl to MS SQL on Linux
> > >
> > >
> > > Rusty--
> > >
> > > In addition to the DBD driver (in this case, DBD::ODBC),
> you need a
> > > database specific ODBC driver for MS SQL. AFAIK, there are
> > no freely
> > > available MS SQL ODBC drivers for linux.
> > >
> > > I've had a similar problem recently in trying to connect to
> > SQL Server
> > > from a RedHat box. The solution I've gone with is DBD::Proxy with
> > > DBD::ODBC on the Windows machine to allow the linux box
> to connect.
> > > There's a page somewhere with instructions on doing just this;
> > > unfortunately, I don't have the URL.
> > >
> > > FWIW, in order to make this setup work reliably, I had to patch
> > > Net::Daemon and PlRPC on the Windows machine with a patch supplied
> > > [EMAIL PROTECTED]
> > >
> > > Let me know if you have any questions. =)
> > >
> > > --TWH
> > >
> > > -----Original Message-----
> > > From: Russell Kroboth [mailto:[EMAIL PROTECTED]
> > > Sent: Monday, February 24, 2003 9:27 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: connecting perl to MS SQL on Linux
> > >
> > >
> > > I have a number of perl scripts used under Windows that I
> > am trying to
> > > port to a Redhat 8 Linux machine. All my scripts use DBI.pm and
> > > DBD::ODBC to connect to an MS SQL Server database.
> > >
> > > I have seen this question several times here, and found
> several FAQs
> > > that all say that I need to simply install a driver manager
> > > and a driver
> > > on my Linux machine. So I thought I would install unixODBC as
> > > the driver
> > > manager, and then DBD:ODBC as my driver. I downloaded
> and installed
> > > unixODBC-2.2.2-3.i386.rpm. However, during the next step -
> > > installation
> > > of DBD:ODBC - I get the following error:
> > >
> > > Using DBI 1.32 installed in
> > > /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto
> > > /DBI
> > >
> > > The DBD::ODBC module needs to link with an ODBC 'Driver
> > Manager'. (The
> > > Driver Manager, in turn, needs one or more database specific ODBC
> > > drivers. The DBD::ODBC module does _not_ include any ODBC
> drivers!)
> > >
> > > You need to indicate where your ODBC Driver Manager is
> > installed. You
> > > can do this ether by setting the ODBCHOME environment
> variable or by
> > > runing 'perl Makefile.PL -o odbcdir'.
> > >
> > > If you do not have an ODBC Driver Manager you can try
> > > building the free
> > > iODBC Driver Manager in the iodbcsrc directory.
> > >
> > > Makefile.PL aborted.
> > >
> > >
> > >
> > > According to the FAQ's I can find, and the unixODBC manual,
> > > this should
> > > not occur since I have installed the driver manager. Am I missing
> > > something? Or doing this wrong?
> > >
> > >
> > > Thanks!
> > > Rusty
> > >
> > >
> >
