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