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
