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 Truncok 1
ok 11 - Set Print Error
ok 12 - Select Long data
ok 13 - Set Long Truncok 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'
ok 28 - test ping method
ok 29 - Attrib odbc_ignore_named_placeholders 0 to start
ok 30 - Attrib odbc_ignore_named_placeholders set to 1
ok 31 - test connecting twice to the same database
ok 32 - database name is returned successfully
ok 33 - automatically finish when execute run again
ok 34 - INVALID DSN Test: [unixODBC][Driver Manager]Data source name not
found, and no default driver specified (SQL-IM002)(DBD:
db_login/SQLConnect err=-1)
#
ok 35 - Connection with DSN=
ok 36 - Connection with DSN= and uid and pwd are set
# Looks like you failed 1 test of 36.
dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 27
Failed 1/36 tests, 97.22% okay
t/03dbatt........1..24
ok 1 - use DBI;
ok 2 - use ODBCTEST;
ok 3 - Set Long Read Len
ok 4 - AutoCommit set on dbh
ok 5 - commitTest with AutoCommit
ok 6 - AutoCommit turned off
ok 7 - commitTest with AutoCommit off
ok 8 - Ensure autocommit back on
ok 9 - sth {NAME} returns ref to array isa ARRAY
ok 10 - Column test for table_info 0
ok 11 - Column test for table_info 1
ok 12 - Column test for table_info 2
ok 13 - Column test for table_info 3
ok 14 - Column test for table_info 4
ok 15 - must be some tables out there?
ok 16 - tables returnes array
ok 17 - column info returns more than one row for test table
ok 18 - primary key count
ok 19 - prepare update statement returns valid sth
ok 20 - update statement has 0 columns returned
ok 21 - update statement has 0 columns returned 2
ok 22 - Verify odbc_query_timeout set ok
ok 23 - verify dbh setting for query_timeout passed to sth
ok 24 - verify sth query_timeout can be overridden
ok
t/05meth.........1..8
ok 1 - use DBI;
ok 2 - delete prepared statement
ok 3 - Number of rows > 0
ok 4 - Number of rows from DBI matches sth
ok 5 - finished and rolled back
ok 6 - no error
ok 7 - ?
ok 8 - ??
ok
t/07bind.........1..11
ok 1 - use ODBCTEST;
ok 2 - Create tables
ok 3 - Table insert test
ok 4 - Ensure long readlen set correctly
ok 5 - Select tests
ok 6 - Insert with bind tests
ok 7 - select long test data
ok 8 - update long test data
ok 9 - select long test data again
ok 10 - ParamValues test integer
ok 11 - Paramvalues test string
ok
t/08bind2........1..5
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 - insert \#1 various test data no dates, no long data
ok 4 - insert \#2 various test data no dates, with long data
ok 5 - insert \#3 various test data data with dates
ok
t/09multi........1..7
ok 1 - use strict;
ok 2 - use DBI;
ok 3 - use ODBCTEST;
ok 4 - count number of result sets
ok 5 - Multiple result sets with different column counts (less then
more)
ok 6 - Multiple result sets with different column counts (more then
less)
ok 7 - Multiple result sets with multiple cols, then second result set
with one col
ok
t/20SqlServer....1..37
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 - errors on data comparison
ok 4 - temporary table handling
ok 5 - bind param in out with insert result set
ok 6 - test output params accurate
ok 7 - verify select data
ok 8 - timestamp handling
ok 9 - procedure outputs results as result set
ok 10 - procedure outputs results as result set2
ok 11 - procedure outputs results as result set 3
ok 12 - setting force_rebind
ok 13 - resetting force_rebind
ok 14 - testing force rebind after procedure call
ok 15 - force rebind test part 2
ok 16 - force rebind test part 3
ok 17 - force rebind test part 4
ok 18 - forced rebind final
ok 19 - Select data available
ok 20 - output param not yet available
ok 21 - output param not yet available2
ok 22 - Output param data available
ok 23 - Output param data available 2
ok 24 - select data done
ok 25 - valid output data
ok 26 - test procedure with no input params
ok 27 - test odbc_async_exec attribute set
===> state: 01000 msg: DBCC execution completed. If DBCC printed error
messages, contact your system administrator. nativeerr: 2528
===> state: 01000 msg: Trace option(s) not enabled for this connection.
Use 'DBCC TRACEON()'. nativeerr: 7941
ok 28 - dbcc messages being returned
ok 29 - reset async exec
ok 30 - test setting odbc_exec_direct
===> state: 01000 msg: START nativeerr: 0
ok 31 - Valid select results with print statements
===> state: 01000 msg: END nativeerr: 0
ok 32 - ensure 2 error messages from two print statements
ok 33 - validate error messages being retrieved
===> state: HY000 msg: Connection is busy with results for another hstmt
nativeerr: 0
ok 34 - Multiple concurrent statements should fail
ok 35 - Multiple concurrent statements succeed (odbc_cursortype set)
ok 36 - passed timeout on query using odbc_query_timeout using do with
bind params
ok 37 - passed timeout on query using odbc_query_timeout using do
without bind params
ok
t/30Oracle.......1..4
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 # skip Oracle tests not supported using Microsoft SQL Server
ok 4 # skip Oracle tests not supported using Microsoft SQL Server
ok
2/4 skipped: Oracle tests not supported using Microsoft SQL
Server
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------------------
-------
t/02simple.t 1 256 36 1 2.78% 27
2 subtests skipped.
Failed 1/9 test scripts, 88.89% okay. 1/137 subtests failed, 99.27%
okay.
make: *** [test_dynamic] Error 29
Here is the output of perl -v:
# perl -V
Summary of my perl5 (revision 5 version 8 subversion 6) configuration:
Platform:
osname=solaris, osvers=2.10, archname=sun4-solaris
uname='sunos devweb 5.10 generic sun4u sparc sunw,sun-fire-v210 '
config_args='-de -Dcc=gcc -Dprefix=/usr/perl5.8.6'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O',
cppflags='-fno-strict-aliasing -pipe -I/usr/local/include'
ccversion='', gccversion='3.3.2', gccosandvers='solaris2.10'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib '
libpth=/usr/local/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc
perllibs=-lsocket -lnsl -ldl -lm -lc
libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under solaris
Compiled at Feb 24 2005 10:16:14
@INC:
/usr/perl5.8.6/lib/5.8.6/sun4-solaris
/usr/perl5.8.6/lib/5.8.6
/usr/perl5.8.6/lib/site_perl/5.8.6/sun4-solaris
/usr/perl5.8.6/lib/site_perl/5.8.6
/usr/perl5.8.6/lib/site_perl
