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? > -----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 > > > > > > > >
