ODBC Connection to Progress on Ubuntu

budfrog532

New Member
Using the Ubuntu-based VM installation from Infobright/Pentaho - working on a data warehouse/BI solution pulling data from our Progress based ERP system.

Progress version 9.1e

Steps I have taken
1) Installed 9.1e on Ubuntu
2) Set DLC path in /etc/environment
3) ran ldd * in /usr/dlc/odbc/lib to determine library issues, and had to add /usr/dlc/odbc/lib, usr/dlc/lib and usr/lib to LD_LIBRARY_PATH --- ldd * runs clean now
4) Set up an odbc.ini file with connection settings that work just fine on my WinXP box
5) Installed iodbc to allow me to use a graphical interface to set up DSN's -- sorry Linux guys, I needed something graphical

I am able to add the driver pointing to /usr/dlc/odbc/lib/pgpro918.so, and then pointing to my .ini file

When I try to test the connection I get the message "IM003 [iODBC][Driver Manager]Specified driver could not be loaded" and then I get the message I can't figure out:
"00000 [iODBC][Driver Manager]/usr/dlc/lib/libprosqlsp.so: undefined symbol: _ls_7ostreamPCv"

I am a relative newbie on Progress, so trying to hunt and peck my way through this. Any help would be appreciated. I have the Pentaho stuff working like a charm on M$xp, but would much rather run all of this on the Ubuntu VM from the vendor.
 
"ubuntu" is a NOT supported OS for Progress.

Here is the reference:
http://web.progress.com/customer-service/product-life-cycle.html

The SQL92 engine builded-in Progress database is also linked with the java version you use.
To get him works you have to respect exactely the java version mentioned in Aviailability Guide.

"ubuntu" has a different shared library configuration.

My I use "mandriva" which is unsupported configuration too and 99% of things works but the rest 1%
not works (like: sqlexp, jdbc, odbc). For me is fine like this, and I ignore ODBC/JDBC,
but if you wants to get the system works you have to respect the "Aviailability Guide", else,
you can spend a lot of time on this and the result can be "?".

You can find the good combination of libstdc++.so.6 , libstdc++-3-libc6.2-2-2.10.0.so
but is not easy ...

... play to the Lottery, the chance to win is better :)
 
thanks for the advice, I understand it is not supported, I wasn't really trying to get Progress to install, just to get the ODBC drivers set up so I can pull data over.

I understand from other posts here on ProgressTalk that there are many other techniques than ODBC to do that, so it's back to the drawing board...

Thanks again.
 
What is the flavor of Progress you are trying to install (suse, redhat, 32 bit, 64 bit?).
For 9,1e you can buy a Linux client for odbc, if you had a more recent version then you could download it for free.
I know that progress 10.1B runs fine on ubuntu (apart from some libstdc++ issue during install which is easily resolved), so I dont see any real reason why it wouldn't work.
What java version are you using by the way?

But as mentioned earlier, ubuntu is unsuported and I never tested it, so I don;t know if it will work. I've never seen the error you got and couldn't find anything reagrding the error in the KB.

Regards,

Casper.
 
I can affirm that 10.1B works just fine on an Ubuntu Hardy 8.04 32bit installation. I use it only for ODBC connections to a RHEL 64bit 10.1b progress database.
 
Thanks for the feedback - I am using version 9.1e, can't move to 10.x until my application vendor catches up.

Am working on another rabbit trail connecting using a couple of different techniques, will be working through that with a developer next week, will post back the results of our conversations/testing.
 
Back
Top