On Mon, 2003-02-24 at 12:49, Russell Kroboth wrote: > I did download .94 and attempted 'perl Makefile.PL', but I get the following > error: > > Please set SYBASE in CONFIG, or set the $SYBASE environment variable at > Makefile.PL line 90, <IN> line 39. > > I'm not sure what it's asking for?
Sybase expects the root of the Sybase installation to be in $SYBASE, so DBD::Sybase does the same thing. If you don't have Sybase but want to use DBD::Sybase with FreeTDS then you should set SYBASE to /usr/local/freetds before building DBD::Sybase. This should be explained on the FreeTDS site, I believe. Michael > > -----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
