Install problems with DBD::ODBC

--=_alternative 004F2BADC125718B_=
Content-Type: text/plain; charset="US-ASCII"

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


--=_alternative 004F2BADC125718B_=--

Re: Install problems with DBD::ODBC

Why don't you use DBD::Pg?

perl -MCPAN -e "install 'DBD::pg'"

Alexander

On 12.06.2006 16:24, scarmalt@iec.ch wrote:

>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
>
>
>
>


--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/

Re: Install problems with DBD::ODBC

On Mon, 12 Jun 2006 17:37:22 +0200, Alexander Foken wrote:

Hi Alexander

> Why don't you use DBD::Pg?

because, as OP was kind enough to explain...

>> (Speed-readers please note, this is Progress, not Postgres)!!

unless of course you have some reason for believing the PostgreSQL driver=
will
work with Progress :-)).

--
Cheers
Ron Savage, ron@savage.net.au on 13/06/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company