DBD::ODBC make test fails

rconner_at_commspeed.net
Date: 12/21/04 

Date: Mon, 20 Dec 2004 16:49:25 -0700 (MST)
To: dbi-users@perl.org

Well I am having some trouble getting DBD::ODBC up and running and so here
I am. I was unable to get to http://www.fugue.com/dbi, but I sent an
email to the dbi-requests email address. I am not even sure I can send an
email here if I am not a user but I am giving this a shot anyways.

I am running Fedora Core 3.

I installed DBI
That seemed to go fine
no errors but i didnt configure any ini or anything yet..still default
(incase that matters)

I set Env. Variables:
export DBI_DSN=dbi:ODBC:myserver1
export DBI_USER=myUN
export DBI_PASS=myPW
That seemed fine

Installed iodbc to /usr/local/stow/iodbc-3.52.1
That seemed fine

export LD_LIBRARY_PATH=/usr/local/stow/iodbc-3.52.1/
That seemed fine and I see this now in the PATH
*now I only did this because Makefile.PL for DBD::ODBC kept saying it
wasnt there.
*but it still says that so I am not sure whats up.

Now trying to get the DBD::ODBC installed is where I am having issues.
I run perl Makefile.PL -o /usr/local/stow/iodbc-3.52.1/
that seems ok However it reports
"WARNING: LD_LIBRARY_PATH doesn't include =/usr/local/stow/iodbc-3.52.1/"
This is odd since I can see it in the env
But it does pick up all the DBI_DSN USER and PASS.
"make" seems fine
"make test" has many errors and fails all over the place.

Here is what I have for perl Makefile.PL, make, make test, and make test
VERBOSE.

[root@localhost DBD-ODBC-1.13]# perl Makefile.PL -o
/usr/local/stow/iodbc-3.52.1/
Useless use of private variable in void context at Makefile.PL line 431.
Overriding ODBC Directory with command line option:
/usr/local/stow/iodbc-3.52.1/

Configuring DBD::ODBC ...

>>> Remember to actually *READ* the README file!
        And re-read it if you have any problems.

Using DBI 1.46 (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/
Overriding ODBC Directory with command line option:
/usr/local/stow/iodbc-3.52.1/
Using ODBC in /usr/local/stow/iodbc-3.52.1/

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/stow/iodbc-3.52.1//lib/libodbc.a
/usr/local/stow/iodbc-3.52.1//lib/libodbc.so library. in $ODBCHOME/lib

Warning: LD_LIBRARY_PATH doesn't include /usr/local/stow/iodbc-3.52.1/

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.46 (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:myserver1 e.g. dbi:ODBC:demo
    DBI_USER=myUN
    DBI_PASS=myPW

[root@localhost 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/stow/iodbc-3.52.1//include -I.
-I/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/
-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -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/stow/iodbc-3.52.1//include ODBC.cgcc -c
-I/usr/local/stow/iodbc-3.52.1//include -I.
-I/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/
-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -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/stow/iodbc-3.52.1//include dbdimp.c
dbdimp.c: In function `odbc_db_execdirect':
dbdimp.c:403: warning: passing arg 2 of `SQLRowCount' from incompatible
pointer type
dbdimp.c: In function `dbd_error2':
dbdimp.c:960: warning: passing arg 5 of `SQLError' from incompatible pointer
type
dbdimp.c: In function `odbc_describe_col':
dbdimp.c:4000: warning: passing arg 7 of `SQLDescribeCol' from incompatible
pointer type
dbdimp.c: In function `AllODBCErrors':
dbdimp.c:4239: warning: passing arg 5 of `SQLError' from incompatible pointer
type
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/stow/iodbc-3.52.1//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@localhost 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 2/36DBI
connect('CompatInterop','compatinterop_write',...)
failed: [iODBC][Driver Manager]Data source name not found and no default
driver specified. Driver could not be loaded (SQL-IM002)(DBD:
db_login/SQLConnect err=-1) at t/02simple.t line 21
Undefined subroutine &main::BAILOUT called at t/02simple.t line 23.
# Looks like you planned 36 tests but only ran 2.
# Looks like your test died just after 2.
t/02simple.......dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3-36
        Failed 34/36 tests, 5.56% okay
t/03dbatt........ok 2/24DBI
connect('CompatInterop','compatinterop_write',...)
failed: [iODBC][Driver Manager]Data source name not found and no default
driver specified. Driver could not be loaded (SQL-IM002)(DBD:
db_login/SQLConnect err=-1) at t/03dbatt.t line 24
Undefined subroutine &main::BAILOUT called at t/03dbatt.t line 26.
# Looks like you planned 24 tests but only ran 2.
# Looks like your test died just after 2.
t/03dbatt........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3-24
        Failed 22/24 tests, 8.33% okay
t/05meth.........ok 1/8DBI connect('CompatInterop','compatinterop_write',...)
failed: [iODBC][Driver Manager]Data source name not found and no default
driver specified. Driver could not be loaded (SQL-IM002)(DBD:
db_login/SQLConnect err=-1) at t/05meth.t line 24
Undefined subroutine &main::BAILOUT called at t/05meth.t line 26.
# Looks like you planned 8 tests but only ran 1.
# Looks like your test died just after 1.
t/05meth.........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-8
        Failed 7/8 tests, 12.50% okay
t/07bind.........ok 1/11DBI
connect('CompatInterop','compatinterop_write',...)
failed: [iODBC][Driver Manager]Data source name not found and no default
driver specified. Driver could not be loaded (SQL-IM002)(DBD:
db_login/SQLConnect err=-1) at t/07bind.t line 22
Undefined subroutine &main::BAILOUT called at t/07bind.t line 24.
# Looks like you planned 11 tests but only ran 1.
# Looks like your test died just after 1.
t/07bind.........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-11
        Failed 10/11 tests, 9.09% okay
t/08bind2........ok 2/5DBI connect('CompatInterop','compatinterop_write',...)
failed: [iODBC][Driver Manager]Data source name not found and no default
driver specified. Driver could not be loaded (SQL-IM002)(DBD:
db_login/SQLConnect err=-1) at t/08bind2.t line 26
Undefined subroutine &main::BAILOUT called at t/08bind2.t line 28.
# Looks like you planned 5 tests but only ran 2.
# Looks like your test died just after 2.
t/08bind2........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3-5
        Failed 3/5 tests, 40.00% okay
t/09multi........ok 3/7DBI connect('CompatInterop','compatinterop_write',...)
failed: [iODBC][Driver Manager]Data source name not found and no default
driver specified. Driver could not be loaded (SQL-IM002)(DBD:
db_login/SQLConnect err=-1) at t/09multi.t line 26
Undefined subroutine &main::BAILOUT called at t/09multi.t line 28.
# Looks like you planned 7 tests but only ran 3.
# Looks like your test died just after 3.
t/09multi........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-7
        Failed 4/7 tests, 42.86% okay
t/20SqlServer....ok 2/37DBI
connect('CompatInterop','compatinterop_write',...)
failed: [iODBC][Driver Manager]Data source name not found and no default
driver specified. Driver could not be loaded (SQL-IM002)(DBD:
db_login/SQLConnect err=-1) at t/20SqlServer.t line 47
Undefined subroutine &main::BAILOUT called at t/20SqlServer.t line 49.
# Looks like you planned 37 tests but only ran 2.
# Looks like your test died just after 2.
t/20SqlServer....dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3-37
        Failed 35/37 tests, 5.41% okay
t/30Oracle.......ok 2/4DBI connect('CompatInterop','compatinterop_write',...)
failed: [iODBC][Driver Manager]Data source name not found and no default
driver specified. Driver could not be loaded (SQL-IM002)(DBD:
db_login/SQLConnect err=-1) at t/30Oracle.t line 26
Undefined subroutine &main::BAILOUT called at t/30Oracle.t line 28.
# Looks like you planned 4 tests but only ran 2.
# Looks like your test died just after 2.
t/30Oracle.......dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3-4
        Failed 2/4 tests, 50.00% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/02simple.t 255 65280 36 68 188.89% 3-36
t/03dbatt.t 255 65280 24 44 183.33% 3-24
t/05meth.t 255 65280 8 14 175.00% 2-8
t/07bind.t 255 65280 11 20 181.82% 2-11
t/08bind2.t 255 65280 5 6 120.00% 3-5
t/09multi.t 255 65280 7 8 114.29% 4-7
t/20SqlServer.t 255 65280 37 70 189.19% 3-37
t/30Oracle.t 255 65280 4 4 100.00% 3-4
Failed 8/9 test scripts, 11.11% okay. 117/137 subtests failed, 14.60% okay.
make: *** [test_dynamic] Error 255

[root@localhost 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;
DBI connect('CompatInterop','compatinterop_write',...) failed: [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver
could not be loaded (SQL-IM002)(DBD: db_login/SQLConnect err=-1) at
t/02simple.t line 21
Undefined subroutine &main::BAILOUT called at t/02simple.t line 23.
# Looks like you planned 36 tests but only ran 2.
# Looks like your test died just after 2.
dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3-36
        Failed 34/36 tests, 5.56% okay
t/03dbatt........1..24
ok 1 - use DBI;
ok 2 - use ODBCTEST;
DBI connect('CompatInterop','compatinterop_write',...) failed: [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver
could not be loaded (SQL-IM002)(DBD: db_login/SQLConnect err=-1) at
t/03dbatt.t line 24
Undefined subroutine &main::BAILOUT called at t/03dbatt.t line 26.
# Looks like you planned 24 tests but only ran 2.
# Looks like your test died just after 2.
dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3-24
        Failed 22/24 tests, 8.33% okay
t/05meth.........1..8
ok 1 - use DBI;
DBI connect('CompatInterop','compatinterop_write',...) failed: [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver
could not be loaded (SQL-IM002)(DBD: db_login/SQLConnect err=-1) at
t/05meth.t
line 24
Undefined subroutine &main::BAILOUT called at t/05meth.t line 26.
# Looks like you planned 8 tests but only ran 1.
# Looks like your test died just after 1.
dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-8
        Failed 7/8 tests, 12.50% okay
t/07bind.........1..11
ok 1 - use ODBCTEST;
DBI connect('CompatInterop','compatinterop_write',...) failed: [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver
could not be loaded (SQL-IM002)(DBD: db_login/SQLConnect err=-1) at
t/07bind.t
line 22
Undefined subroutine &main::BAILOUT called at t/07bind.t line 24.
# Looks like you planned 11 tests but only ran 1.
# Looks like your test died just after 1.
dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-11
        Failed 10/11 tests, 9.09% okay
t/08bind2........1..5
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
DBI connect('CompatInterop','compatinterop_write',...) failed: [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver
could not be loaded (SQL-IM002)(DBD: db_login/SQLConnect err=-1) at
t/08bind2.t line 26
Undefined subroutine &main::BAILOUT called at t/08bind2.t line 28.
# Looks like you planned 5 tests but only ran 2.
# Looks like your test died just after 2.
dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3-5
        Failed 3/5 tests, 40.00% okay
t/09multi........1..7
ok 1 - use strict;
ok 2 - use DBI;
ok 3 - use ODBCTEST;
DBI connect('CompatInterop','compatinterop_write',...) failed: [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver
could not be loaded (SQL-IM002)(DBD: db_login/SQLConnect err=-1) at
t/09multi.t line 26
Undefined subroutine &main::BAILOUT called at t/09multi.t line 28.
# Looks like you planned 7 tests but only ran 3.
# Looks like your test died just after 3.
dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-7
        Failed 4/7 tests, 42.86% okay
t/20SqlServer....1..37
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
DBI connect('CompatInterop','compatinterop_write',...) failed: [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver
could not be loaded (SQL-IM002)(DBD: db_login/SQLConnect err=-1) at
t/20SqlServer.t line 47
Undefined subroutine &main::BAILOUT called at t/20SqlServer.t line 49.
# Looks like you planned 37 tests but only ran 2.
# Looks like your test died just after 2.
dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3-37
        Failed 35/37 tests, 5.41% okay
t/30Oracle.......1..4
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
DBI connect('CompatInterop','compatinterop_write',...) failed: [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver
could not be loaded (SQL-IM002)(DBD: db_login/SQLConnect err=-1) at
t/30Oracle.t line 26
Undefined subroutine &main::BAILOUT called at t/30Oracle.t line 28.
# Looks like you planned 4 tests but only ran 2.
# Looks like your test died just after 2.
dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3-4
        Failed 2/4 tests, 50.00% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/02simple.t 255 65280 36 68 188.89% 3-36
t/03dbatt.t 255 65280 24 44 183.33% 3-24
t/05meth.t 255 65280 8 14 175.00% 2-8
t/07bind.t 255 65280 11 20 181.82% 2-11
t/08bind2.t 255 65280 5 6 120.00% 3-5
t/09multi.t 255 65280 7 8 114.29% 4-7
t/20SqlServer.t 255 65280 37 70 189.19% 3-37
t/30Oracle.t 255 65280 4 4 100.00% 3-4
Failed 8/9 test scripts, 11.11% okay. 117/137 subtests failed, 14.60% okay.

Any ideas?

Thanks for the help,

Ryan

Relevant Pages

  • Re: Perl 6 DBI API ideas
    ... Though I didn't raise my hand when you asked for people to contribute to a DBI module for Perl 6, I've had some ideas that I thought about sharing. ... I would also love to see some standardization on the driver names ("mysql" when it's normally written ... DBI is supposed to be query language agnostic, even if SQL is the most commonly used group of languages, and if a user can declare this explicitly, it saves the driver from having to guess what they were given, which might be ambiguous. ...
    (perl.dbi.users)
  • Re: DBI and character sets (yet again)
    ... I don't really want the DBI to be involved in any recoding ... When selecting data from the database the driver should: ... - return strings which have a unicode character set as UTF8. ... - return strings with other character sets as-is on ...
    (perl.dbi.users)
  • RE: ORACLE DRIVER
    ... DBI - is the perl module to handle all the request of the database, connecting, disconnecting, routing the database request to proper driver. ... DBD::Oracle - is the Oracle driver that DBI can use to handle oracle request. ...
    (perl.dbi.users)
  • Re: Accessing VFP9 data from Perl/JSP pages being served from Apache/Linux?
    ... There is a dbi driver for ADO, you might be able to use that to get to VFP ...
    (microsoft.public.fox.programmer.exchange)
  • RE: [dbi] DBD::ODBC make test fails
    ... this looks like a unixodbc type of driver manager. ... The Makefile seems to think you've got unixODBC but you say you've got iodbc. ... FAILED tests 3-36 ... > ok 2 - use ODBCTEST; ...
    (perl.dbi.users)