Without looking at the perldoc, have you double-checked the pre-test requirements for MSSQL ?<br>Maybe google the results of testing DBD::ODBC against MSSQL and db requirements and environment flags before running tests.<br>
multi-platform testing is a pain and I'll bet this is just a "do this before that" issue.<br><br>Anyway, looks like the test is expecting table PERL_DBD_TABLE1 to be created sometime during or before testing.<br>
<br>Happy trails <br><br clear="all">Peter Fitzgibbons<br>(847) 687-7646<br>Email: <a href="mailto:peter.fitzgibbons@gmail.com">peter.fitzgibbons@gmail.com</a><br>IM GTalk: peter.fitzgibbons<br>IM Yahoo: pjfitzgibbons<br>
IM MSN: <a href="mailto:pjfitzgibbons@hotmail.com">pjfitzgibbons@hotmail.com</a><br>IM AOL: <a href="mailto:peter.fitzgibbons@gmail.com">peter.fitzgibbons@gmail.com</a><br>
<br><br><div class="gmail_quote">On Fri, Oct 24, 2008 at 10:02 PM, <span dir="ltr"><<a href="mailto:younda@rcn.com">younda@rcn.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Hi, </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">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.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">(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.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I'm using:</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">perl Makefile.PL MAKE=dmake</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">dmake</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">dmake test TEST_VERBOSE=1 </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I've tried doing the tests using a local Access
database DSN, SQL Server DSN, and Excel file DSN. They all fail (slightly
differently).</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">The errors below are when using SQL Server 2000.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Any ideas what may be causing the problem?</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">ydy</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">not ok 13 - ...inserted one row# Failed test
'...inserted one row'</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># at t/07bind.t line 118.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># got:
'0'</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># expected: '1'</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">ok 14 - insert with named placeholders</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">not ok 15 - ...inserted one row</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># Failed test '...inserted one row'</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># at t/07bind.t line 132.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># got:
'0'</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># expected: '1'</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># Looks like you failed 2 tests of 16.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">ok 16 - no warnings</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Dubious, test returned 2 (wstat 512, 0x200)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Failed 2/16 subtests</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">t/08bind2...............</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">not ok 54 - no warnings</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># Failed test 'no warnings'</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># at t/20SqlServer.t line 27.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># There were 3 warning(s)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># Previous test 9 ''</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># DBD::ODBC::db do
failed: [Microsoft][ODBC SQL Server Driver][SQL Server]</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Cannot drop the table 'PERL_DBD_TABLE1', because it does not
exist in the system</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> catalog. (SQL-42S02) at t/20SqlServer.t line 90.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># at t/20SqlServer.t line 90</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># eval {...} called at
t/20SqlServer.t line 90</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">#
main::varmax_test('DBI::db=HASH(0xbd75bc)', 'varchar') called at t/20Sql</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Server.t line 131</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">#</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># ----------</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># Previous test 13 ''</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># DBD::ODBC::db do
failed: [Microsoft][ODBC SQL Server Driver][SQL Server]</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Cannot drop the table 'PERL_DBD_TABLE1', because it does not
exist in the system</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> catalog. (SQL-42S02) at t/20SqlServer.t line 90.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># at t/20SqlServer.t line 90</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># eval {...} called at
t/20SqlServer.t line 90</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">#
main::varmax_test('DBI::db=HASH(0xbd75bc)', 'varbinary') called at t/20S</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">qlServer.t line 132</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">#</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># ----------</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># Previous test 17 ''</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># DBD::ODBC::db do
failed: [Microsoft][ODBC SQL Server Driver][SQL Server]</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Cannot drop the table 'PERL_DBD_TABLE1', because it does not
exist in the system</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> catalog. (SQL-42S02) at t/20SqlServer.t line 90.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># at t/20SqlServer.t line 90</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># eval {...} called at
t/20SqlServer.t line 90</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">#
main::varmax_test('DBI::db=HASH(0xbd75bc)', 'nvarchar') called at t/20Sq</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">lServer.t line 133</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">#</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"># Looks like you failed 1 test of 54.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Dubious, test returned 1 (wstat 256, 0x100)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Failed 1/54 subtests</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> (less 13 skipped
subtests: 40 okay)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Test Summary Report</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">-------------------</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">t/07bind
(Wstat: 512 Tests: 16 Failed: 2)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Failed tests: 13, 15</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Non-zero exit status: 2</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">t/20SqlServer (Wstat:
256 Tests: 54 Failed: 1)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Failed test: 54</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Non-zero exit status: 1</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Files=15, Tests=349, 12 wallclock secs ( 0.30 usr +
0.03 sys = 0.33 CPU)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Result: FAIL</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Failed 2/15 test programs. 3/349 subtests failed.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">dmake: Error code 255, while making 'test_dynamic'</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">C:\strawberry\cpan\build\DBD-ODBC-1.17-9UgrBo></span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
</div>
<br>_______________________________________________<br>
Chicago-talk mailing list<br>
<a href="mailto:Chicago-talk@pm.org">Chicago-talk@pm.org</a><br>
<a href="http://mail.pm.org/mailman/listinfo/chicago-talk" target="_blank">http://mail.pm.org/mailman/listinfo/chicago-talk</a><br></blockquote></div><br>