DBD::Sybase expects to find the libraries in $SYBASE/lib and the include files in $SYBASE/include. I believe that the default FreeTDS install places these files in /usr/local/lib and /usr/local/include, in which case you need to set $SYBASE to /usr/local.
Michael On Tue, 2003-02-25 at 13:26, Russell Kroboth wrote: > 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 > > > > > > > > > > > -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] http://www.mbay.net/~mpeppler Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.mbay.net/~mpeppler/resume.html
