[Chicago-talk] Problems building DBD::ODBC

[younda at rcn.com]

Hi, 

 

I'm trying to build DBD::ODBC on a Windows 2003 Server running Strawberry
Perl.  The README for DBD::ODBC suggests that you build it by hand, because
there are problems if you do it using the CPAN shell.

(I tried it, and it doesn't work)  I can make the Makefile, and it builds
just fine.  But when you run make test, it comes back with the 3 errors
shown below.

 

I'm using:

 

perl Makefile.PL MAKE=dmake

dmake

dmake test TEST_VERBOSE=1  

 

I've tried doing the tests using a local Access database DSN, SQL Server
DSN, and Excel file DSN.  They all fail (slightly differently).

The errors below are when using SQL Server 2000.

 

Any ideas what may be causing the problem?

 

ydy

 

 

 

not ok 13 - ...inserted one row#   Failed test '...inserted one row'

 

#   at t/07bind.t line 118.

#          got: '0'

#     expected: '1'

ok 14 - insert with named placeholders

 

not ok 15 - ...inserted one row

#   Failed test '...inserted one row'

#   at t/07bind.t line 132.

#          got: '0'

#     expected: '1'

# Looks like you failed 2 tests of 16.

ok 16 - no warnings

 Dubious, test returned 2 (wstat 512, 0x200)

 Failed 2/16 subtests

t/08bind2...............

 

not ok 54 - no warnings

#   Failed test 'no warnings'

#   at t/20SqlServer.t line 27.

# There were 3 warning(s)

#       Previous test 9 ''

#       DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
Server]

Cannot drop the table 'PERL_DBD_TABLE1', because it does not exist in the
system

 catalog. (SQL-42S02) at t/20SqlServer.t line 90.

#  at t/20SqlServer.t line 90

#       eval {...} called at t/20SqlServer.t line 90

#       main::varmax_test('DBI::db=HASH(0xbd75bc)', 'varchar') called at
t/20Sql

Server.t line 131

#

# ----------

#       Previous test 13 ''

#       DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
Server]

Cannot drop the table 'PERL_DBD_TABLE1', because it does not exist in the
system

 catalog. (SQL-42S02) at t/20SqlServer.t line 90.

#  at t/20SqlServer.t line 90

#       eval {...} called at t/20SqlServer.t line 90

#       main::varmax_test('DBI::db=HASH(0xbd75bc)', 'varbinary') called at
t/20S

qlServer.t line 132

#

# ----------

#       Previous test 17 ''

#       DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
Server]

Cannot drop the table 'PERL_DBD_TABLE1', because it does not exist in the
system

 catalog. (SQL-42S02) at t/20SqlServer.t line 90.

#  at t/20SqlServer.t line 90

#       eval {...} called at t/20SqlServer.t line 90

#       main::varmax_test('DBI::db=HASH(0xbd75bc)', 'nvarchar') called at
t/20Sq

lServer.t line 133

#

# Looks like you failed 1 test of 54.

 Dubious, test returned 1 (wstat 256, 0x100)

 Failed 1/54 subtests

        (less 13 skipped subtests: 40 okay)

 

 

Test Summary Report

-------------------

t/07bind            (Wstat: 512 Tests: 16 Failed: 2)

  Failed tests:  13, 15

  Non-zero exit status: 2

t/20SqlServer       (Wstat: 256 Tests: 54 Failed: 1)

  Failed test:  54

  Non-zero exit status: 1

Files=15, Tests=349, 12 wallclock secs ( 0.30 usr +  0.03 sys =  0.33 CPU)

Result: FAIL

Failed 2/15 test programs. 3/349 subtests failed.

dmake:  Error code 255, while making 'test_dynamic'

 

C:\strawberry\cpan\build\DBD-ODBC-1.17-9UgrBo>

 

 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/chicago-talk/attachments/20081024/4bc533b0/attachment.html>