RE: Problem installing DBD::ODBC 1.13

From: Jeff Urlwin (jurlwin_at_esoftmatic.com)
Date: 03/02/05 

To: "'Jonathan Gillespie'" <jgillespie@Jaeb.org>, <dbi-users@perl.org>
Date: Wed, 2 Mar 2005 14:59:46 -0500

>
>
> I'm able to install DBD::ODBC 1.11, however, I can not install 1.12 or
> 1.13. Following is a complete log of the steps used to build
> 1.13. If
> anybody has any idea what might be going on, I would appreciate being
> pointed in the right direction.
>
> Thanks,
> Jonathan
>
> # make realclean
> rm -rf ODBC.c ODBC.xsi dbdodbc.h ./blib Makefile.aperl
> blib/arch/auto/DBD/ODBC/extralibs.all
> blib/arch/auto/DBD/ODBC/extralibs.ld perlmain.c tmon.out mon.out
> so_locations pm_to_blib *.o *.a perl.exe perl perl ODBC.bs ODBC.bso
> ODBC.def libODBC.def ODBC.exp ODBC.x core core.*perl.*.? *perl.core
> core.[0-9] core.[0-9][0-9] core.[0-9][0-9][0-9]
> core.[0-9][0-9][0-9][0-9] core.[0-9][0-9][0-9][0-9][0-9]
> mv Makefile Makefile.old > /dev/null 2>&1
> rm -rf blib/lib/auto/DBD/ODBC blib/arch/auto/DBD/ODBC
> rm -rf DBD-ODBC-1.13
> rm -f blib/arch/auto/DBD/ODBC/ODBC.so blib/arch/auto/DBD/ODBC/ODBC.bs
> rm -f blib/arch/auto/DBD/ODBC/ODBC.a
> rm -f blib/lib/DBD/ODBC.pm Makefile.old Makefile
> # perl Makefile.PL
> Useless use of private variable in void context at
> Makefile.PL line 431.
>
> Configuring DBD::ODBC ...
>
> >>> Remember to actually *READ* the README file!
> And re-read it if you have any problems.
>
> Using DBI 1.47 (for perl 5.008006 on sun4-solaris) installed in
> /usr/perl5.8.6/lib/site_perl/5.8.6/sun4-solaris/auto/DBI/
> Using ODBC in /usr/local/easysoft/unixODBC
>
> Umm, this looks like a unixodbc type of driver manager.
> We expect to find the sql.h, sqlext.h and (which were
> supplied with unixODBC) in $ODBCHOME/include directory alongside
> the /usr/local/easysoft/unixODBC/lib/libodbc.so library. in
> $ODBCHOME/lib
>
>
> Checking if your kit is complete...
> Looks good
> Injecting selected odbc driver into cc command
> Injecting selected odbc driver into cc command
> Using DBI 1.47 (for perl 5.008006 on sun4-solaris) installed in
> /usr/perl5.8.6/lib/site_perl/5.8.6/sun4-solaris/auto/DBI/
> Writing Makefile for DBD::ODBC
>
> The DBD::ODBC tests will use these values for the database connection:
> DBI_DSN=dbi:ODBC:dsn_Northwind e.g. dbi:ODBC:demo
> DBI_USER=webuser
> DBI_PASS=test
>
> # make
> cp Changes blib/lib/DBD/ODBC/Changes.pm
> cp ODBC.pm blib/lib/DBD/ODBC.pm
> /usr/bin/perl -p -e "s/~DRIVER~/ODBC/g"
> /usr/perl5.8.6/lib/site_perl/5.8.6/sun4-solaris/auto/DBI//Driver.xst >
> ODBC.xsi
> /usr/bin/perl /usr/perl5.8.6/lib/5.8.6/ExtUtils/xsubpp -typemap
> /usr/perl5.8.6/lib/5.8.6/ExtUtils/typemap ODBC.xs > ODBC.xsc && mv
> ODBC.xsc ODBC.c
> Warning: duplicate function definition 'data_sources' detected in
> ODBC.xs, line 202
> gcc -c -I/usr/local/easysoft/unixODBC/include -I.
> -I/usr/perl5.8.6/lib/site_perl/5.8.6/sun4-solaris/auto/DBI/
> -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.13\" -DXS_VERSION=\"1.13\"
> -fPIC "-I/usr/perl5.8.6/lib/5.8.6/sun4-solaris/CORE"
> -I/usr/local/easysoft/unixODBC/include ODBC.c
> gcc -c -I/usr/local/easysoft/unixODBC/include -I.
> -I/usr/perl5.8.6/lib/site_perl/5.8.6/sun4-solaris/auto/DBI/
> -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.13\" -DXS_VERSION=\"1.13\"
> -fPIC "-I/usr/perl5.8.6/lib/5.8.6/sun4-solaris/CORE"
> -I/usr/local/easysoft/unixODBC/include dbdimp.c
> Running Mkbootstrap for DBD::ODBC ()
> chmod 644 ODBC.bs
> rm -f blib/arch/auto/DBD/ODBC/ODBC.so
> LD_RUN_PATH="/usr/local/easysoft/unixODBC/lib" gcc -G
> -L/usr/local/lib
> ODBC.o dbdimp.o -o blib/arch/auto/DBD/ODBC/ODBC.so
> -L/usr/local/easysoft/unixODBC/lib -lodbc
> chmod 755 blib/arch/auto/DBD/ODBC/ODBC.so
> cp ODBC.bs blib/arch/auto/DBD/ODBC/ODBC.bs
> chmod 644 blib/arch/auto/DBD/ODBC/ODBC.bs
> Manifying blib/man3/DBD::ODBC.3
> # make test TEST_VERBOSE=1
> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harness(1, 'blib/lib', 'blib/arch')" t/*.t
> t/01base.........1..5
> ok 1 - require DBI;
> ok 2 - import DBI
> ok 3 - DBI->internal is DBI::dr
> ok 4 - Install ODBC driver OK
> ok 5 - Version is not empty
> ok
> t/02simple.......1..36
> ok 1 - use DBI;
> ok 2 - use ODBCTEST;
> ok 3 - Set Auto commit
> ok 4 - Auto commit retrieved to what was set
> ok 5 - create test table
> ok 6 - test table exists
> ok 7 - insert test data
> ok 8 - select test data
> ok 9 - Set Long Read len
> ok 10 - Set Long Trun*** 1
> ok 11 - Set Print Error
> ok 12 - Select Long data
> ok 13 - Set Long Trun*** 0
> ok 14 - Select Long Data failure
> ok 15 - prepare select from table
> ok 16 - Execute select
> ok 17 - Col count matches correct col count
> ok 18 - Set RaiseError 0
> ok 19 - Set PrintError 0
> ok 20 - Error reported on bad query
> ok 21 - date check select
> ok 22 - date check execute
> ok 23 - date check rows
> ok 24 - group by query prepare
> ok 25 - group by query execute
> ok 26 - group by query returned rows
> not ok 27 - data sources test
>
> # Failed test (t/02simple.t at line 132)
> # '0'
> # >
> # '0'

First -- I think it's pretty safe to install this version, unless you require the use of
the data_sources() function.

Second -- I'm thinking something is strange (and it could, of course be DBD::ODBC). The
test that is failing is acting as if you don't have any data sources defined, yet it seems
that you are using a DSN to connect. What's the value of your DBI_DSN environment
variable? What version of unixODBC are you using?

Thanks,

Jeff