Hi folks --
I've got Easysoft's latest ODBC-Sybase driver installed, and I can connect to my Sybase
database at the command line with "isql sunline". However, I'm having trouble
getting DBD::ODBC installed. I've included complete information (except my username and
password) below. At least, I think I have; if I've omitted something important, please
let me know.
Can anyone tell me what I'm doing wrong?
Regards,
Ben Ostrowsky
[EMAIL PROTECTED] DBD-ODBC-1.13]# 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
[EMAIL PROTECTED] DBD-ODBC-1.13]# 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.
Multiple copies of Driver.xst found in:
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ at
Makefile.PL line 61
Using DBI 1.50 (for perl 5.008005 on i386-linux-thread-multi) installed in
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/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
Use of uninitialized value in pattern match (m//) at Makefile.PL line 272.
Warning: LD_LIBRARY_PATH doesn't include /usr/local/easysoft/unixODBC
Checking if your kit is complete...
Looks good
Injecting selected odbc driver into cc command
Injecting selected odbc driver into cc command
Multiple copies of Driver.xst found in:
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ at
Makefile.PL line 462
Using DBI 1.50 (for perl 5.008005 on i386-linux-thread-multi) installed in
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::ODBC
The DBD::ODBC tests will use these values for the database connection:
DBI_DSN=dbi:ODBC:sunline e.g. dbi:ODBC:demo
DBI_USER=[deleted]
DBI_PASS=[deleted]
[EMAIL PROTECTED] DBD-ODBC-1.13]# 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/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI//Driver.xst > ODBC.xsi
/usr/bin/perl /usr/lib/perl5/5.8.5/ExtUtils/xsubpp -typemap
/usr/lib/perl5/5.8.5/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/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING
-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-I/usr/include/gdbm -O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -DVERSION=\"1.13\"
-DXS_VERSION=\"1.13\" -fPIC "-I/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE"
-I/usr/local/easysoft/unixODBC/include ODBC.c
gcc -c -I/usr/local/easysoft/unixODBC/include -I.
-I/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING
-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-I/usr/include/gdbm -O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -DVERSION=\"1.13\"
-DXS_VERSION=\"1.13\" -fPIC "-I/usr/lib/perl5/5.8.5/i386-linux-thread-multi/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
gcc -shared -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.3pm
[EMAIL PROTECTED] DBD-ODBC-1.13]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/01base.........ok
t/02simple.......ok 16/36# Coltype -3 not found in list # 93, 91, 9, 11#
# Failed test (t/02simple.t at line 76)
# got: '3'
# expected: '4'
t/02simple.......ok 26/36# Failed test (t/02simple.t at line 132)
t/02simple.......NOK 27# '0'
# >
# '0'
t/02simple.......ok 36/36# Looks like you failed 2 tests of 36.
t/02simple.......dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 17, 27
Failed 2/36 tests, 94.44% okay
t/03dbatt........ok
t/05meth.........ok
t/07bind.........ok 2/11DBD::ODBC::st execute failed: at t/ODBCTEST.pm line 228.
t/07bind.........ok 4/11# Failed test (t/07bind.t at line 61)
t/07bind.........ok 11/11# Looks like you failed 1 tests of 11.
t/07bind.........dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 5
Failed 1/11 tests, 90.91% okay
t/08bind2........ok
3/5 skipped: SQLDescribeParam not supported using [Adaptive Server Enterprise]
t/09multi........ok
t/20SqlServer....ok
35/37 skipped: Microsoft SQL Server tests not supported using [Adaptive Server Enterprise]
t/30Oracle.......ok
2/4 skipped: Oracle tests not supported using [Adaptive Server Enterprise]
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/02simple.t 2 512 36 2 5.56% 17 27
t/07bind.t 1 256 11 1 9.09% 5
40 subtests skipped.
Failed 2/9 test scripts, 77.78% okay. 3/137 subtests failed, 97.81% okay.
make: *** [test_dynamic] Error 255
[EMAIL PROTECTED] DBD-ODBC-1.13]# 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
# Coltype -3 not found in list # 93, 91, 9, 11#
# Failed test (t/02simple.t at line 76)
# got: '3'
# expected: '4'
not 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
# Failed test (t/02simple.t at line 132)
not ok 27 - data sources test
# '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 2 tests of 36.
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 17, 27
Failed 2/36 tests, 94.44% 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
DBD::ODBC::st execute failed: at t/ODBCTEST.pm line 228.
ok 3 - Table insert test
ok 4 - Ensure long readlen set correctly
Column C value failed! bind value = 6, returned values = 6| | |¯ï¼
# Failed test (t/07bind.t at line 61)
not 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
# Looks like you failed 1 tests of 11.
dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 5
Failed 1/11 tests, 90.91% okay
t/08bind2........1..5
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 # skip SQLDescribeParam not supported using [Adaptive Server Enterprise]
#
ok 4 # skip SQLDescribeParam not supported using [Adaptive Server Enterprise]
#
ok 5 # skip SQLDescribeParam not supported using [Adaptive Server Enterprise]
#
ok
3/5 skipped: SQLDescribeParam not supported using [Adaptive Server
Enterprise]
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 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 4 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 5 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 6 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 7 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 8 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 9 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 10 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 11 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 12 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 13 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 14 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 15 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 16 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 17 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 18 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 19 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 20 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 21 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 22 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 23 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 24 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 25 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 26 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 27 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 28 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 29 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 30 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 31 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 32 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 33 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 34 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 35 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 36 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok 37 # skip Microsoft SQL Server tests not supported using [Adaptive Server
Enterprise]
ok
35/37 skipped: Microsoft SQL Server tests not supported using [Adaptive
Server Enterprise]
t/30Oracle.......1..4
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 # skip Oracle tests not supported using [Adaptive Server Enterprise]
ok 4 # skip Oracle tests not supported using [Adaptive Server Enterprise]
ok
2/4 skipped: Oracle tests not supported using [Adaptive Server
Enterprise]
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/02simple.t 2 512 36 2 5.56% 17 27
t/07bind.t 1 256 11 1 9.09% 5
40 subtests skipped.
Failed 2/9 test scripts, 77.78% okay. 3/137 subtests failed, 97.81% okay.
make: *** [test_dynamic] Error 255
[EMAIL PROTECTED] DBD-ODBC-1.13]# perl -V
Summary of my perl5 (revision 5 version 8 subversion 5) configuration:
Platform:
osname=linux, osvers=2.6.9-22.18.bz155725.elsmp,
archname=i386-linux-thread-multi
uname='linux hs20-bc1-4.build.redhat.com 2.6.9-22.18.bz155725.elsmp #1 smp
thu nov 17 15:34:08 est 2005 i686 i686 i386 gnulinux '
config_args='-des -Doptimize=-O2 -g -pipe -m32 -march=i386 -mtune=pentium4
-Dversion=5.8.5 -Dmyhostname=localhost [EMAIL PROTECTED] -Dcc=gcc -Dcf_by=Red
Hat, Inc. -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux
-Dvendorprefix=/usr -Dsiteprefix=/usr -Duseshrplib -Dusethreads -Duseithreads
-Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db -Ui_ndbm -Di_gdbm -Di_shadow
-Di_syslog -Dman3ext=3pm -Duseperlio -Dinstallusrbinperl -Ubincompat5005
-Uversiononly -Dpager=/usr/bin/less -isr -Dinc_version_list=5.8.4 5.8.3 5.8.2
5.8.1 5.8.0'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define
usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING
-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
optimize='-O2 -g -pipe -m32 -march=i386 -mtune=pentium4',
cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe
-I/usr/local/include -I/usr/include/gdbm'
ccversion='', gccversion='3.4.5 20051201 (Red Hat 3.4.5-1)', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
libc=/lib/libc-2.3.4.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version='2.3.4'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E
-Wl,-rpath,/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE'
cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: DEBUGGING MULTIPLICITY USE_ITHREADS USE_LARGE_FILES PERL_IMPLICIT_CONTEXT
Built under linux
Compiled at Dec 16 2005 14:06:35
@INC:
/usr/lib/perl5/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/5.8.5
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl/5.8.2
/usr/lib/perl5/vendor_perl/5.8.1
/usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl
.
[EMAIL PROTECTED] DBD-ODBC-1.13]#
