Installing DBD::ODBC Perl -> Progress 9.1e

[snakes20]

I'm trying to connect to a progress 9.1e database with perl using the ODBC drivers from progress.

I can't seem to get DBD::ODBC module to install...any suggestions or am I taking the wrong route here??

On a linux box, Red Hat

I am able to connect via the sample C programs provided by progress to connect via ODBC drivers and the dsn setup in the .odbc.ini file.


Here is what i've done:
- created the .odbc.ini file and set ODBCINI
- Set ODBCHOME variable to the ODBC install directory
- Set DBI_DSN, DBI_USER, and DBI_PASS variables
- Set LD_LIBRARY_PATH and PATH to include ODBC library path


Download and unzip DBD::ODBC from cpan
Modify Makefile.PL based on a data direct document #2973 "Configuring the PERL DBD::ODBC module to support the Connect for ODBC drivers on Unix"

> perl Makefile.PL

runs fine, but make doesn't

$ make
gcc -c   -I. -I/opt/progress/odbc//include -I/usr/lib/perl5/site_perl/5.8.0/i386
-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDE
BUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OF
FSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -march=i386 -mcpu=i686   -DVERSION
=\"1.17\" -DXS_VERSION=\"1.17\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-
multi/CORE"   ConvertUTF.c
gcc -c   -I. -I/opt/progress/odbc//include -I/usr/lib/perl5/site_perl/5.8.0/i386
-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDE
BUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OF
FSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -march=i386 -mcpu=i686   -DVERSION
=\"1.17\" -DXS_VERSION=\"1.17\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-
multi/CORE"   ODBC.c
In file included from ODBC.h:17,
                 from ODBC.xs:1:
dbdimp.h:100: syntax error before "SQLLEN"
dbdimp.h:100: warning: no semicolon at end of struct or union
dbdimp.h:119: syntax error before '}' token
dbdimp.h:128: syntax error before "SQLULEN"
dbdimp.h:128: warning: no semicolon at end of struct or union
dbdimp.h:132: syntax error before "ColLength"
dbdimp.h:132: warning: data definition has no type or storage class
dbdimp.h:133: syntax error before "ColDisplaySize"

......
 
 
ODBC.xsi:704: dereferencing pointer to incomplete type
ODBC.xsi:705: dereferencing pointer to incomplete type
ODBC.xsi:710: dereferencing pointer to incomplete type
ODBC.xsi:711: dereferencing pointer to incomplete type
ODBC.xsi:711: dereferencing pointer to incomplete type
ODBC.xsi:711: dereferencing pointer to incomplete type
ODBC.xsi:713: dereferencing pointer to incomplete type
ODBC.xsi:714: dereferencing pointer to incomplete type
ODBC.xsi:723: dereferencing pointer to incomplete type
ODBC.xsi:723: dereferencing pointer to incomplete type
ODBC.xsi:723: dereferencing pointer to incomplete type
ODBC.xsi: In function `boot_DBD__ODBC':
ODBC.xsi:23: sizeof applied to an incomplete type
make: *** [ODBC.o] Error 1

 

[snakes20]

After further playing around, I decided to give UnixODBC a shot. I installed unixODBC (http://unixodbc.org) and UnixODBC module from cpan. Still can't get DBD::ODBC installed using unixodbc as driver manager, trying to connect with UnixODBC gives the following error:

[unixODBC][Driver Manager]Can't open lib '/opt/progress/odbc/lib/pgpro918.so' : libpgmfront.so: cannot open shared object file: No such file or directory

Both files are in the directory though.


When I try to make DBD::ODBC I get same error message when using unixodbc and when I use intersolve type driver manager.