Running perl 5.8.1 (multi-thread - beyond my control) on SUSE 9.2.
DBI is 1.48. DBD::Oracle works OK. Am attempting to get ODBC
working in order to connect to Progress Database. ODBC drivers
(with appropriate Progress license) installed; Progress
version 9.1E. The PROGRESS/UNIX/ODBC drivers are actually written
by MERANT, Inc.
(Speed-readers please note, this is Progress, not Postgres)!!
Progress-supplied Drivers have names like
pgpro918.so, odbctrac.so, etc., so I have followed
instructions for Solaris, where UNIX flavors differ.
Testing fails with simple test 4 - Auto commit retrieved
to what was set.
Error message "Unable to find a suitable test type for
field COL_C at t/ODBCTEST.pm line 64. And from there on
the test results go downhill. Any pointers on how to get
up and running will be appreciated.
Thanks and regards,
Sam Carmalt
Background of warnings, etc., prior to running make test
***
Problems solved (I think) so far:
-- Lines 41, 42, 90 & 91 of dbdimp.h start with /* in
the middle of a comment ( /* ... */ ); hand-edited
include file to ** in each of these 4 instances.
-- No supplied sqlucode.h file, so have used the one
in the demonstration verions of DataDirect drivers.
Seems to be unicode stuff.
***
Running perl Makefile.PL then gives the following:
Useless use of private variable in void context at Makefile.PL line 431.
Using ODBC in /usr/local/dlc/odbc
Umm, this looks like a unixodbc type of driver manager
***
Running make seems to be OK, although there are a number of
warning messages:
Warning: duplicate function definition 'data_sources' detected in ODBC.xs,
line
202
dbdimp.c: In function `odbc_clear_result_set':
dbdimp.c:143: warning: unused variable `inner'
dbdimp.c: In function `dbd_preparse':
dbdimp.c:1159: warning: unused variable `param'
dbdimp.c: In function `odbc_describe':
dbdimp.c:1614: warning: unused variable `t_dsize'
dbdimp.c: In function `odbc_st_finish':
dbdimp.c:2412: warning: unused variable `ret'
dbdimp.c: In function `_dbd_get_param_type':
dbdimp.c:2509: warning: unused variable `supported'
dbdimp.c:2909:65: warning: "/*" within comment
dbdimp.c: At top level:
dbdimp.c:2958: warning: return type defaults to `int'
dbdimp.c: In function `odbc_db_STORE_attrib':
dbdimp.c:3078: warning: unused variable `imp_drh'
dbdimp.c:3083: warning: unused variable `cachesv'
dbdimp.c: In function `odbc_db_FETCH_attrib':
dbdimp.c:3325: warning: unused variable `imp_drh'
dbdimp.c: In function `odbc_st_STORE_attrib':
dbdimp.c:3695: warning: unused variable `imp_dbh'
dbdimp.c:3699: warning: unused variable `value'
*** Then make test starts failing with t/02.4
