kp2a has asked for the wisdom of the Perl Monks concerning the following question:

Having a problem installing DBD::ODBC on a i386 Fedora 8 box. --- perl Makfile.PL returns 
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 running 'perl Makefile.PL -o odbcdir'.

If you do not have an ODBC Driver Manager you should try to get hold of
the unixODBC packages for your system or build it from source (see
http://www.unixodbc.org).
root@scan DBD-ODBC-1.15#
yet I installed unixODBC via yum but I cannot find any directory that will make Makefile.PL happy. 
root@scan DBD-ODBC-1.15# yum info unixODBC
Installed Packages
Name   : unixODBC
Arch   : i386
Version: 2.2.12
Release: 5.fc8
Size   : 2.0 M
Repo   : installed
help!

Replies are listed 'Best First'.
Re: How to install DBD::ODBC Fedora 8
by Fletch (Bishop) on Feb 06, 2008 at 18:19 UTC

    (Not that it's a Perl problem, but . . . )

    For many RPMs there's a companion "-devel" RPM which contains the headers and what not necessary to build other software against. What you've installed most likely just has the runtime library and utilities only.

    The cake is a lie.
    The cake is a lie.
    The cake is a lie.

[reply]
Re: How to install DBD::ODBC Fedora 8
by Khen1950fx (Canon) on Feb 06, 2008 at 04:19 UTC
    First, make sure that DBI is setup properly.

    Next:
    export set LD_LIBRARY_PATH=/usr/lib

    Then run Makefile.PL

[reply]
      same results with LD_LIBRARY_PATH=/usr/lib
      similar results using -o option --- additionally Makefile.PL lists drivers it knows
      odbcinit in default location
      DBI installed and in use for some time 
      . . .
Overriding ODBC Directory with command line option: /usr/lib
Using ODBC in /usr/lib

Hmm...I cannot find an ODBC driver manager that I recognize.
...And I know about these drivers:
        Microsoft ODBC, adabas, easysoft, empress, esodbc, informix,
        intersolve, iodbc, sapdb, solid, udbc, unixodbc
root@scan DBD-ODBC-1.15# ls /usr/bin/odbc*
/usr/bin/odbc_config  /usr/bin/odbcinst
root@scan DBD-ODBC-1.15# perl -e 'use DBI;'
root@scan DBD-ODBC-1.15#
[reply]

Back to Seekers of Perl Wisdom