unixODBC on CentOS trying to connect to Oracle...

Installation and support for Oracle DB on CentOS.
Post Reply
jjo_chicago
Posts: 1
Joined: 2010/01/19 15:48:21

unixODBC on CentOS trying to connect to Oracle...

Post by jjo_chicago » 2010/01/19 17:09:31

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!

pschaff
Retired Moderator
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America
Contact:

unixODBC on CentOS trying to connect to Oracle...

Post by pschaff » 2010/01/20 20:44:34

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

Post Reply