Scott Stansbury wrote:
> Getting closer :)
>
> I'm trying to connect to a SQL Server 2008 instance from a CentOS5 box:
>
> unixODBC: 2.2.14
> FreeTDS: 0.82
> Easysoft: odbc-sqlserver-1.1.26-linux-x86 (this morning, thank you
> again Martin and Wez...)
>
> osql/isql work fine with both the FreeTDS and the Easysoft drivers.
>
> Connecting to a SQL Server 2008 instance running on a Server 2008 box.
>
> DBB::ODBC make test fails as follows:
>
> [r...@server1 DBD-ODBC-1.22-D2_Zne]# make test
> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/01base.t .............. ok
> t/02simple.t ............ 3/65 #
> # Perl 5.8.8
> # osname=linux, osvers=2.6.18-53.el5, archname=i386-linux-thread-multi
> # Using DBI 1.609
> # Using DBD::ODBC 1.22
> # Using DBMS_NAME 'Microsoft SQL Server'
> # Using DBMS_VER '10.00.1600'
> # Using DRIVER_NAME 'libessqlsrv.so'
> # Using DRIVER_VER '01.01.0026'
> # odbc_has_unicode 0
> t/02simple.t ............ 35/65
> # Failed test 'data sources test'
> # at t/02simple.t line 259.
> # '0'
> # >
> # '0'
> # Looks like you failed 1 test of 65.
> t/02simple.t ............ Dubious, test returned 1 (wstat 256, 0x100)
> Failed 1/65 subtests
> t/03dbatt.t ............. 3/29 #
> # N.B. Some drivers (postgres/cache) may return ODBC 2.0 column names
> for the SQLTables result-set e.g. TABLE_QUALIFIER instead of TABLE_CAT
> t/03dbatt.t ............. ok
> t/05meth.t .............. ok
> t/07bind.t .............. ok
> t/08bind2.t ............. ok
> t/09multi.t ............. ok
> t/10handler.t ........... ok
> t/12blob.t .............. ok
> t/20SqlServer.t ......... ok
> t/30Oracle.t ............ ok
> t/40UnicodeRoundTrip.t .. ok
> t/41Unicode.t ........... ok
> t/pod-coverage.t ........ ok
> t/pod.t ................. ok
> t/rt_38977.t ............ ok
> t/rt_39841.t ............ ok
> t/rt_39897.t ............ ok
> t/rt_43384.t ............ ok
> t/rt_46597.t ............ ok
> t/rt_null_nvarchar.t .... ok
>
> Test Summary Report
> -------------------
> t/02simple.t (Wstat: 256 Tests: 65 Failed: 1)
> Failed test: 56
> Non-zero exit status: 1
> Files=21, Tests=445, 33 wallclock secs ( 0.02 usr 0.26 sys + 0.27
> cusr 2.17 csys = 2.72 CPU)
> Result: FAIL
> Failed 1/21 test programs. 1/445 subtests failed.
> make: *** [test_dynamic] Error 255
>
> As always, thanks!
>
> Best regards,
> Scott...
>
>
Scott,
Sorry for not answering sooner - somehow I missed your follow up.
The test that fails is looking for a data source i.e., it called
DBI->data_sources('ODBC') and it should be testing the returned array to
check there is more than 0 entries but in fact it does:
cmp_ok($#data_sources, '>', 0, "data sources test");
so if you only have one data source it fails. You can rectify the test
yourself by changing the > above to >=.
This does not indicate any problem with the driver your are using or
your setup.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
