RE: Problem installing DBD::ODBC 1.13

From: Jonathan Gillespie (jgillespie_at_Jaeb.org)
Date: 03/02/05 

Date: Wed, 2 Mar 2005 15:17:39 -0500
To: "Jeff Urlwin" <jurlwin@esoftmatic.com>, <dbi-users@perl.org>

>> t/02simple.......1..36
>> ok 1 - use DBI;
>> ok 2 - use ODBCTEST;
>> ok 3 - Set Auto commit
>> ok 4 - Auto commit retrieved to what was set ok 5 - create test table

>> ok 6 - test table exists ok 7 - insert test data ok 8 - select test
>> data ok 9 - Set Long Read len ok 10 - Set Long Trun*** 1 ok 11 - Set
>> Print Error ok 12 - Select Long data ok 13 - Set Long Trun*** 0 ok 14

>> - Select Long Data failure ok 15 - prepare select from table ok 16 -
>> Execute select ok 17 - Col count matches correct col count ok 18 -
Set
>> RaiseError 0 ok 19 - Set PrintError 0 ok 20 - Error reported on bad
>> query ok 21 - date check select ok 22 - date check execute ok 23 -
>> date check rows ok 24 - group by query prepare ok 25 - group by query

>> execute ok 26 - group by query returned rows not ok 27 - data sources

>> test
>>
>> # Failed test (t/02simple.t at line 132)
>> # '0'
>> # >
>> # '0'
>
>First -- I think it's pretty safe to install this version, unless you
>require the use of the data_sources() function.
>
>Second -- I'm thinking something is strange (and it could, of course be

>DBD::ODBC). The test that is failing is acting as if you don't have
any
>data sources defined, yet it seems that you are using a DSN to connect.

>What's the value of your DBI_DSN environment variable? What version of

>unixODBC are you using?
>
>Thanks,
>
>Jeff

DBI_DSN=dbi:ODBC:dsn_Northwind
unixODBC 2.2.10

FYI, the make test for v 1.11 of DBD::ODBC is able to find this, here is
a
sinp from the make test verbose command, the enviroment is the same from
my
previous posting, I just changed to the source directoy for 1.11.

Thanks,
Jonathan

Sinp from output of DBD::ODBC 1.11: make test TEST_VERBOSE=1
t/02simple.......1..21
ok 1
 Test 2: connecting to the database
ok 2
 Test 3: create test table
Using fields: COL_A smallint NOT NULL PRIMARY KEY , COL_B varchar(8000),
COL_C text, COL_D datetime
ok 3
 Test 4: check existance of test table
(unknown owner).PERL_DBD_TEST
ok 4
 Test 5: insert test data
ok 5
 Test 6: select test data
1|foo|foo varchar|
2|bar|bar varchar|
3|bletch|bletch varchar|
4|80char|THIS IS A STRING LONGER THAN 80 CHARS. THIS SHOULD BE CHECKED
FOR TRUNCATION AND COMPARED WITH ITSELF.|
5|gt250char|THIS IS A STRING LONGER THAN 80 CHARS. THIS SHOULD BE
CHECKED FOR TRUNCATION AND COMPARED WITH ITSELF. THIS IS A STRING
LONGER THAN 80 CHARS. THIS SHOULD BE CHECKED FOR TRUNCATION AND
COMPARED WITH ITSELF. THIS IS A STRING LONGER THAN 80 CHARS. THIS
SHOULD BE CHECKED FOR TRUNCATION AND COMPARED WITH ITSELF. THIS IS A
STRING LONGER THAN 80 CHARS. THIS SHOULD BE CHECKED FOR TRUNCATION AND
COMPARED WITH ITSELF.|
retrieved 103 byte string OK
retrieved 418 byte string OK
ok 6
 Tests 7,8: test LongTrun***
ok 7
ok 8
 Test 9: test ColAttributes
Column count is: 4
1: COL_A = 5 5 yes
2: COL_B = 12 12 yes
3: COL_C = -1 -1 yes
4: COL_D = 11 11 yes

ok 9
 Test 10: test $DBI::err
ok 10
 Test 11: test date or timestamp values
1998-05-14 00:00:00.000
ok 11
 Test 12: test group by queries
1, 1
2, 1
3, 1
4, 1
5, 1
ok 12
 Test 13: test data_sources
Data sources:
        DBI:ODBC:dsn_Northwind

ok 13
 Test 14: test ping method
ok 14
 Test 15: test storing of DBH parameter
ok 15
Attrib not true (1)
 Test 16: test connecting twice to the same db.
ok 16
 Test 17: test get_info
 connected to Microsoft SQL Server
ok 17
 Test 18: test automatically finish when execute run again
ok 18
 Test 19: test connection success when DBI DSN is invalid
Test Ok if Errstr not undef: [unixODBC][Driver Manager]Data source name
not found, and no default driver specified (SQL-IM002)(DBD:
db_login/SQLConnect err=-1)
ok 19
 Test 20: test connection success when DBI DSN has DSN=
ok 20
 Test 21: test connection success when DBI DSN has DSN= and uid and pwd
are set
ok 21
ok