Last night, I upgraded my CentOS from 5.3 --> 5.4. Of course, there is
no upgrade for unixODBC, but there is a ton of other upgrades. Result:


[mgogala at (no spam) medo work]$ isql ora10 scott tiger
+---------------------------------------+ | Connected!
| | | | sql-statement
| | help [tablename] | | quit
| |
| +---------------------------------------+ SQL> select * from
user_tables;
isql: symbol lookup error: /usr/lib/oracle/10.2.0.3/client/lib//
libsqora.so.10.1: undefined symbol: _VEC_memzero [mgogala at (no spam) medo work]$

This used to work and now it doesn't. As 10g ODBC drivers are no longer
supported, there is nobody to complain to. Of course, the 11g drivers
are incompatible with the current release of the unixODBC driver
manager:

[mgogala at (no spam) medo work]$ isql ora11 scott tiger isql: symbol lookup error:
/usr/lib/oracle/11.2/client/lib/ libsqora.so.11.1: undefined symbol:
SQLGetPrivateProfileStringW [mgogala at (no spam) medo work]$


The trick would be to pull the latest source and run

./configure prefix=/usr

but that would mess up the installed packages system and instantaneously
render the whole thing unsupported. I am eagerly awaiting somebody to
create the much needed RPM packages and put them into one of the
available repositories. I am downloading the DVD with Oracle EL 5.4, in
order to see whether it has the right version of the driver manager.
Fortunately, RR is rather fast and that will be done quickly.

I am downloading the DVD with Oracle EL 5.4, in order to see whether it
has the right version of the driver manager. Fortunately, RR is rather
fast and that will be done quickly.

BTW, did anybody manage to successfully install the latest Tora on CentOS
5.x or RH EL 5.x?

On Sat, 24 Oct 2009 05:22:29 +0000, Mladen Gogala wrote:

I am downloading the DVD with Oracle EL 5.4, in order to see whether it
has the right version of the driver manager. Fortunately, RR is rather
fast and that will be done quickly.

OEL doesn't have the right version, either. It's still unixODBC 2.2.11.
The problem was reported to Red Hat in December 2008, still unresolved.
I am starting to believe that the big boys are playing politics:

https://bugzilla.redhat.com/show_bug.cgi?id=475615

The solution is described here:
http://kuroyi.net/category/odbc/

Of course, it's unsupported to link the driver manager from the source.
If any form of technical assistance is needed, you will be out of luck.
My impression is that the state of ODBC on Linux is really sad on purpose
because interoperability isn't in the best interest of the big software
vendors.

Or maybe that interface is just too infrequently used. I guess many
applications that need to run on Linux will either use JDBC or OCI. Do
you think this is a wrong assumption?

On 24 Okt., 07:25, Mladen Gogala <gogala.mla... at (no spam) gmail.com> wrote:

BTW, did anybody manage to successfully install the latest Tora on
CentOS 5.x or RH EL 5.x?

yes, i did. i have tora-2.1.1svn running on RHEL5.4.

-ap

On Sat, 24 Oct 2009 05:32:43 -0700, Andreas Piesk wrote:
On 24 Okt., 07:25, Mladen Gogala <gogala.mla... at (no spam) gmail.com> wrote:

BTW, did anybody manage to successfully install the latest Tora on
CentOS 5.x or RH EL 5.x?

yes, i did. i have tora-2.1.1svn running on RHEL5.4.

I was able to install 2.1.0 RPM after installing qt-4.5 but not 2.1.1.

what errors did you get?
i can send you my spec file, source rpm or binary rpm if you want it.
for building from source you need the latest cmake.

I always built it with an option "--without-kde" or something like that,
because of a bug in the editor. No KDE, no QT i'd guess.

On Sat, 24 Oct 2009 15:14:30 -0700, Andreas Piesk wrote:


what errors did you get?
i can send you my spec file, source rpm or binary rpm if you want it.
for building from source you need the latest cmake.

I was building it from the source, using qt-4.5.2.0.1, it was complaining
about an undefined function. I was able to install tora-2.1.0 though. The
dependency on Qscintilla is quite annoying, it isn't being shipped with
the OS any more and it taints the QT package.