help installing DBD::ODBC

From: Perldiscuss - Perl Newsgroups And Mailing Lists (adambeirne_at_hotmail.com)
Date: 06/15/04


Date: 15 Jun 2004 21:43:26 -0000
To: dbi-users@perl.org

Platform: Windows XP Pro
oDBC Driver Manager: included in windows
backend database: MS Access 2000
Perl version: 5.8.3
Apache version: 2.0.48
DBI version: 1.42
DBD::oDBc version 1.09
MDAC version: 2.8

lil newbie here requiring help. im trying to upgrade from windows to open
source and am installing DBD::ODBC to migrate my web site from from IIS to
Apache. im stuck.

i really cant get the DBD::ODBC module to install. first off, its looking
for the carp.pl file in
C:\Program Files\perl\site\lib\DBI when its actually in C:\Program
Files\perl\lib
not a problem, copied the file over and re-ran NMAKE TEST. now i get the
following errors

[Tue Jun 15 19:52:43 2004] xxxxxxxx.t: Had to create DBD::ODBC::
dr::imp_data_size unexpectedly at C:/Program Files/perl/site/lib/DBI.pm
line 1061.

[Tue Jun 15 19:52:43 2004] xxxxxxx.t: Use of uninitialized value in
subroutine entry
at C:/Program Files/perl/site/lib/DBI.pm line 1061.

followed by

Undefined subroutine &DBD::ODBC::db::_login called at
C:\cygwin\bin\dbdodbc\DBD-OD~1.09\blib\lib/DBD/ODBC.pm line 78.

here is the full report:

----------------------------------------------------------------C:\cygwin\bin\dbdodbc\DBD-ODBC-1.09>nmake
test TEST_VERBOSE=1

Microsoft (R) Program Maintenance Utility Version 1.50
Copyright (c) Microsoft Corp 1988-94. All rights reserved.

Running Mkbootstrap for DBD::ODBC ()
C:\progra~1\perl\bin\perl.exe -MExtUtils::Command -e chmod 644 ODBC.bs
link -out:blib\arch\auto\DBD\ODBC\ODBC.dll -dll -nologo -nodefaultlib
-release -libpath:"C:\PROGRA~\perl\lib\CORE" -machine:x86 ODBC.obj
dbdimp.obj C:\PROGRA~1\perl\lib\CORE\perl58.lib
C:\Progra~1\Micros~3\VC98\lib\ODBC32.LIB
C:\Progra~1\Micros~3\VC98\lib\oldnames.lib
C:\Progra~1\Micros~3\VC98\lib\kernel3
2.lib C:\Progra~1\Micros~3\VC98\lib\user32.lib
C:\Progra~1\Micros~3\VC98\lib\gdi32.lib
C:\Progra~1\Micros~3\VC98\lib\winspool.lib
C:\Progra~1\Micros~3\VC98\lib\comdlg32.lib
C:\Progra~1\Micros~3\VC98\lib\advapi32.lib
C:\Progra~1\Micros~3\VC98\lib\shell32.lib
C:\Progra~1\Micros~3\VC98\lib\ole32.lib
C:\Progra~1\Micros~3\VC98\lib\oleaut32.lib
C:\Progra~1\Micros~3\VC98\lib\netapi32.lib
C:\Progra~1\Micros~3\VC98\lib\uuid.lib
C:\Progra~1\Micros~3\VC98\lib\wsock32.lib C:\Progra~1\Mic
ros~3\VC98\lib\mpr.lib C:\Progra~1\Micros~3\VC98\lib\winmm.lib
C:\Progra~1\Micros~3\VC98\lib\version.lib
C:\Progra~1\Micros~3\VC98\lib\odbc32.lib
C:\Progra~1\Micros~3\VC98\lib\odbccp32.lib
C:\Progra~1\Micros~3\VC98\lib\msvcrt.lib -def:ODBC.
def
Creating library blib\arch\auto\DBD\ODBC\ODBC.lib and object
blib\arch\auto\DBD\ODBC\ODBC.exp

C:\progra~1\perl\bin\perl.exe -MExtUtils::Command -e chmod 755
blib\arch\auto\DBD\ODBC\ODBC.dll

C:\progra~1\perl\bin\perl.exe -MExtUtils::Command -e cp ODBC.bs
blib\arch\auto\DBD\ODBC\ODBC.bs

C:\progra~1\perl\bin\perl.exe -MExtUtils::Command -e chmod 644
blib\arch\auto\DBD\ODBC\ODBC.bs

C:\progra~1\perl\bin\perl.exe "-MExtUtils::Command::MM" "-e"
"test_harness(1, 'blib\lib', 'blib\arch')" t\01base.t

t\02simple.t t\03dbatt.t t\05meth.t t
\07bind.t t\08bind2.t t\09multi.t t\20SqlServer.t t\30Oracle.t

t\01base.........[Tue Jun 15 21:58:56 2004] 01base.t: Had to create
DBD::ODBC::dr::imp_data_size unexpectedly at C:/Program
Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:56 2004] 01base.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
1..5
ok 1
ok 2
ok 3
ok 4
ok 5
ok
t\02simple.......1..21
ok 1
 Test 2: connecting to the database
[Tue Jun 15 21:58:56 2004] 02simple.t: Had to create
DBD::ODBC::dr::imp_data_size unexpectedly at C:/Program
Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:56 2004] 02simple.t: Use of uninitialized value in
subroutine
entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:56 2004] 02simple.t: Had to create
DBD::ODBC::db::imp_data_size unexpectedly at C:/Program
Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:56 2004] 02simple.t: Use of uninitialized value in
subroutine
entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
Undefined subroutine &DBD::ODBC::db::_login called at
C:\cygwin\bin\dbdodbc\DBD-
ODBC-1.09\blib\lib/DBD/ODBC.pm line 78.
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 2-21
Failed 20/21 tests, 4.76% okay

t\03dbatt........1..19
ok 1
[Tue Jun 15 21:58:56 2004] 03dbatt.t: Had to create
DBD::ODBC::dr::imp_data_size unexpectedly at C:/Program
Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:56 2004] 03dbatt.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:56 2004] 03dbatt.t: Had to create
DBD::ODBC::db::imp_data_size
 unexpectedly at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:56 2004] 03dbatt.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
Undefined subroutine &DBD::ODBC::db::_login called at
C:\cygwin\bin\dbdodbc\DBD-ODBC-1.09\blib\lib/DBD/ODBC.pm line 78.
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 2-19
Failed 18/19 tests, 5.26% okay

t\05meth.........1..6
ok 1
[Tue Jun 15 21:58:56 2004] 05meth.t: Had to create
DBD::ODBC::dr::imp_data_size
unexpectedly at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:56 2004] 05meth.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:56 2004] 05meth.t: Had to create
DBD::ODBC::db::imp_data_size
unexpectedly at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:56 2004] 05meth.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
Undefined subroutine &DBD::ODBC::db::_login called at
C:\cygwin\bin\dbdodbc\DBD-ODBC-1.09\blib\lib/DBD/ODBC.pm line 78.
dubious
        Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 2-6
        Failed 5/6 tests, 16.67% okay
t\07bind.........1..10
ok 1
 Test 2: connecting to the database
[Tue Jun 15 21:58:57 2004] 07bind.t: Had to create
DBD::ODBC::dr::imp_data_size
unexpectedly at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:57 2004] 07bind.t: Use of uninitialized value in
subroutine en
try at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:57 2004] 07bind.t: Had to create
DBD::ODBC::db::imp_data_size
unexpectedly at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:57 2004] 07bind.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
Undefined subroutine &DBD::ODBC::db::_login called at
C:\cygwin\bin\dbdodbc\DBD-
ODBC-1.09\blib\lib/DBD/ODBC.pm line 78.
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 2-10
Failed 9/10 tests, 10.00% okay

t\08bind2........[Tue Jun 15 21:58:57 2004] 08bind2.t: Had to create
DBD::ODBC::dr::imp_data_size unexpectedly at C:/Program
Files/perl/site/lib/DBI.pm line 106
1.
[Tue Jun 15 21:58:57 2004] 08bind2.t: Use of uninitialized value in
subroutine e
ntry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:57 2004] 08bind2.t: Had to create
DBD::ODBC::db::imp_data_size
 unexpectedly at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:57 2004] 08bind2.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
Undefined subroutine &DBD::ODBC::db::_login called at
C:\cygwin\bin\dbdodbc\DBD-ODBC-1.09\blib\lib/DBD/ODBC.pm line 78.
dubious
Test returned status 2 (wstat 512, 0x200)

t\09multi........[Tue Jun 15 21:58:57 2004] 09multi.t: Had to create
DBD::ODBC::
dr::imp_data_size unexpectedly at C:/Program Files/perl/site/lib/DBI.pm
line 106
1.
[Tue Jun 15 21:58:57 2004] 09multi.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:57 2004] 09multi.t: Had to create
DBD::ODBC::db::imp_data_size unexpectedly at C:/Program
Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:57 2004] 09multi.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
Undefined subroutine &DBD::ODBC::db::_login called at
C:\cygwin\bin\dbdodbc\DBD-ODBC-1.09\blib\lib/DBD/ODBC.pm line 78.
dubious
Test returned status 2 (wstat 512, 0x200)
t\20SqlServer....[Tue Jun 15 21:58:57 2004] 20SqlServer.t: Had to create
DBD::ODBC::dr::imp_data_size unexpectedly at C:/Program
Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:57 2004] 20SqlServer.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:57 2004] 20SqlServer.t: Had to create
DBD::ODBC::db::imp_data_size unexpectedly at C:/Program
Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:57 2004] 20SqlServer.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
Undefined subroutine &DBD::ODBC::db::_login called at
C:\cygwin\bin\dbdodbc\DBD-ODBC-1.09\blib\lib/DBD/ODBC.pm line 78.
dubious
Test returned status 2 (wstat 512, 0x200)

t\30Oracle.......[Tue Jun 15 21:58:58 2004] 30Oracle.t: Had to create
DBD::ODBC::dr::imp_data_size unexpectedly at C:/Program
Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:58 2004] 30Oracle.t: Use of uninitialized value in
subroutine entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:58 2004] 30Oracle.t: Had to create
DBD::ODBC::db::imp_data_size unexpectedly at C:/Program
Files/perl/site/lib/DBI.pm line 1061.
[Tue Jun 15 21:58:58 2004] 30Oracle.t: Use of uninitialized value in
subroutine
entry at C:/Program Files/perl/site/lib/DBI.pm line 1061.
Undefined subroutine &DBD::ODBC::db::_login called at
C:\cygwin\bin\dbdodbc\DBD-ODBC-1.09\blib\lib/DBD/ODBC.pm line 78.
dubious
Test returned status 2 (wstat 512, 0x200)

Failed Test Stat Wstat Total Fail Failed List of Failed
----------------------------------------------------------------
t\02simple.t 2 512 21 40 190.48% 2-21
t\03dbatt.t 2 512 19 36 189.47% 2-19
t\05meth.t 2 512 6 10 166.67% 2-6
t\07bind.t 2 512 10 18 180.00% 2-10
t\08bind2.t 2 512 ?? ?? % ??
t\09multi.t 2 512 ?? ?? % ??
t\20SqlServer.t 2 512 ?? ?? % ??
t\30Oracle.t 2 512 ?? ?? % ??
Failed 8/9 test scripts, 11.11% okay. 52/61 subtests failed, 14.75% okay.
NMAKE : fatal error U1077: 'C:\WINDOWS.000\system32\cmd.exe' : return code
'0x2'

Stop.

C:\cygwin\bin\dbdodbc\DBD-ODBC-1.09>



Relevant Pages

  • Connection error with DBD-Sybase
    ... I've confirmed that we can connect to a remote database using ... FAILED tests 2-4 ... Server foo, database ... There was an error encountered while establishing the connection. ...
    (perl.dbi.users)
  • Re: DBD::Informix, perl 5.8.5 and Solaris build problem
    ... On Fri, 2004-10-08 at 23:25 +0100, Tim Bunce wrote: ... chmod 755 blib/arch/auto/DBD/Informix/Informix.so ... is not in the database. ... FAILED tests 6-7, 9-16 ...
    (perl.dbi.users)
  • Nessus perl modules and RedHat Enterprise AS v3
    ... centric to RedHat and its Perl and gcc installs. ... Net::Nessus::ScanLite 0.01 perl modules. ... Subroutine new redefined at ... FAILED tests 2-31 ...
    (RedHat)