Re: Installing DBD::ODBC

I guess the relevant section of your output is:

**********
        Remember to actually *READ* the README file!
        And re-read it if you have any problems.    

**********

Looking for odbc_config on PATH
  odbc_config not found        
Looking for iodbc-config on PATH
  iodbc_config not found        
odbc_config not found - ok, there are other things I can do
Still trying to guess ODBCHOME - looking for headers now   
  trying /usr/include                                      
  trying usr/local/include                                 
  trying /usr/pkg/include                                  
  trying /usr/local/easysoft/unixODBC/include              

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

o setting the ODBCHOME environment variable
o running 'perl Makefile.PL -o odbcdir'    
o adding path to odbc_config/iodbc_config to PATH
[download]

So, which one of the three have you done? It seems that your odbc_config program was not installed in one of the common locations, so maybe you want to make sure that the installation of it actually succeeded?

Comment on Re: Installing DBD::ODBC Select or Download Code

Replies are listed 'Best First'.
Re^2: Installing DBD::ODBC by Steve_BZ (Chaplain) on Oct 18, 2009 at 16:05 UTC
Hi Corion, Thanks for your input. It seems to be looking for odbc_config or iodbc_config, neither of which seem to exist anywhere on the machine (after doing a search), I've also searched google and the unixODBC website for clues about where it put ODBCHOME, but I can't find any clues. The unixODBC installation was perfect (from sudo apt-get install unixodbc). So I feel a bit lost. Maybe I should try pipes rather than ODBC, what do you use? Regards Steve	[reply]
Re^3: Installing DBD::ODBC by Corion (Patriarch) on Oct 18, 2009 at 16:10 UTC
How do you know that the unixODBC installation went well when one of the programs that are supposed to get installed with unixODBC is missing? If you are really sure you know where unixODBC got installed to, maybe just set `$ENV{ODBCHOME}` to it. Personally, I use DBD::ODBC on Windows, where it works as advertised, because Windows comes with the ODBC manager.	[reply] [d/l]
Re^4: Installing DBD::ODBC by Bloodnok (Vicar) on Oct 18, 2009 at 17:40 UTC
Personally, I use DBD::ODBC on Windows Hmmm, ease of use apart, doesn't that go against the raison d'etre of ODBC i.e. a platform, database & language neutral database interface - wouldn't we (in the widest sense possible) all benefit from exposing the interface to as many combinations of OS, DB & language as is possible. A user level that continues to overstate my experience :-))	[reply]