Page 1 of 1

unixODBC on CentOS trying to connect to Oracle...

Posted: 2010/01/19 17:09:31
by jjo_chicago
I am trying to use unixODBC on CentOS5 to connect to an Oracle database.

I installed (via yum) unixODBC and unixODBC-devel, both ver 2.2.11

I set up odbcinst.ini and odbc.ini, using the libsqora.so.10.1 that came with the Oracle install.

when I try to execute isql, I get

isql: symbol lookup error: /opt/oracle/102/lib/libsqora.so.10.1: undefined symbol: SQLGetPrivateProfileStringW

...which is a well documented error stemming from the fact the Oracle driver requires unixODBC ver 2.2.12 or greater.

So...my question is

1) Is there a way to get a version of unixODBC higher than 2.2.11 for CentOS 5?

*or*

2) Is there a better driver to use to connect to Oracle that gets along with unixODBC 2.2.11? (And not the EasySoft one you have to license)

Has anyone been able to connect to Oracle via ODBC on CentOS 5?

Thanks in advance!

unixODBC on CentOS trying to connect to Oracle...

Posted: 2010/01/20 20:44:34
by pschaff
I have no experience with it but 2.2.12 is in the [url=http://wiki.centos.org/AdditionalResources/Repositories?highlight=(CentOS-Testing)]CentOS-Testing repo[/url].