Yes, I am using the MS ODBC Driver manager when using cygwin.
See the output from perl Makefile.PL below.
$ perl Makefile.PL
Useless use of private variable in void context at Makefile.PL line 963.
You are using a Perl configured with threading enabled.
Please read the warnings in DBI about this.
You should also be aware that on non-Windows platforms ODBC drivers come
in two forms, thread-safe and non-thread-safe drivers and you may need
to make sure you are using the right one.
Press return to continue...
**********
Remember to actually *READ* the README file!
And re-read it if you have any problems.
**********
Looking for odbc_config at C:/WINDOWS/bin/odbc_config
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
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).
Shawn
-----Original Message-----
From: Martin Evans [mailto:martin.ev...@easysoft.com]
Sent: Wednesday, October 14, 2009 10:11 AM
To: Shawn Zong
Cc: dbi-users@perl.org
Subject: Re: need help to install DBD::ODBC module
Shawn Zong wrote:
> I was installing DBD:ODBC module on latest cgywin 1.5.25-15,
> following the routine install procedure, i.e. 1 perl makefile.pl + 3
> makes. Yes, ODBCHOME was set manually.
>
> However, I have no problem to install DBD:ODBC via PPM. So my perl
> program runs on windows xp command window, but not on cygwin.
>
> Please let me know if you need more information.
>
> Thanks. Shawn
The output from perl Makefile.PL would be useful to see.
I don't use cgywin. odbc_config is a program that comes with later
unixODBC driver managers. Am I right in assuming that when using cygwin
you are still expecting to use the MS ODBC Driver manager?
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
>
>
>
> -----Original Message----- From: Martin Evans
> [mailto:martin.ev...@easysoft.com] Sent: Wednesday, October 14, 2009
> 9:24 AM To: Shawn Zong Cc: dbi-users Subject: Re: need help to
> install DBD::ODBC module
>
> Shawn Zong wrote:
>> I am having difficulty to compile on Perl V5.10.0 built with MS SQL
>> server 2005. The program could not find installed ODBC Driver
>> Manager.
>>
>>
>>
>> Here is my configuration.
>>
>> DBI_DSN: 'dbi:ODBC: DSN_NAME', DSN_NAME is set up in System DSN
>> in ODBC Data source Administrator.
>>
>> DBI_USER: valid database user
>>
>> DBI_PASS: valid password
>>
>> ODBCHOME c:\windows\system32
>>
>>
>>
>> When running ‘perl Makefile.PL’, it could not find odbc_config and
>> then the build failed. Do I miss anything in config?
>>
>>
>>
>> Thanks,
>>
>> Shawn
>>
>
> Hi,
>
> Not finding odbc_config should not stop it working but I have an
> awful feeling about this since it should not be looking for
> odbc_config on windows. Did you set ODBCHOME yourself? Can you send
> the output of perl Makefile.PL please.
>
> Martin
