>
>
> 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:
DBD::ODBC is not the driver (from the ODBC perspective), it's the
"application side". You need:
Perl application --> DBI --> DBD::ODBC --> Driver Manager
(UnixODBC) --> Driver --> (lots of stuff could be here, tcp/ip,
etc...depending upon what level of detail you want) --> database
>
> 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'.
You probably didn't set ODBCHOME.
>
> 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
>
>
>
Regards,
Jeff