[Chicago-talk] Problems building DBD::ODBC

[Peter Fitzgibbons]

Without looking at the perldoc, have you double-checked the pre-test
requirements for MSSQL ?
Maybe google the results of testing DBD::ODBC against MSSQL and db
requirements and environment flags before running tests.
multi-platform testing is a pain and I'll bet this is just a "do this before
that" issue.

Anyway, looks like the test is expecting table PERL_DBD_TABLE1 to be created
sometime during or before testing.

Happy trails

Peter Fitzgibbons
(847) 687-7646
Email: peter.fitzgibbons at gmail.com
IM GTalk: peter.fitzgibbons
IM Yahoo: pjfitzgibbons
IM MSN: pjfitzgibbons at hotmail.com
IM AOL: peter.fitzgibbons at gmail.com


On Fri, Oct 24, 2008 at 10:02 PM, <younda at rcn.com> wrote:

>  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>
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> Chicago-talk mailing list
> Chicago-talk at pm.org
> http://mail.pm.org/mailman/listinfo/chicago-talk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/chicago-talk/attachments/20081025/0f78b4fe/attachment.html>