Re: DBD::ODBC installation problem with Easysoft ODBC-Sybase driver

Ben,

Two testa failed because Sybase does not support data type -3 - that is not a problem.

One test failed because you have not yet defined any data sources in the odbc.ini file - not a problem.

You can ignore these.

Martin

Ben Ostrowsky wrote:

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


[root@helpdesk 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
[root@helpdesk 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]

[root@helpdesk 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
[root@helpdesk 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
[root@helpdesk 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 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
# 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
[root@helpdesk 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 -Dperladmin=root@localhost -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
.
[root@helpdesk DBD-ODBC-1.13]#








.

Quantcast