ODBC client access from Linux for Oracle Database

Hi,

I am running a Redhat Linux 6.2 box, attemping to run a ODBC 3 client application, which accesses an Oracle 8.x database on another machine. I'm not having much luck.

First question - has anybody managed to access an Oracle database server using ODBC calls from linux?
(obviously not easy given ODBC doesn't come packaged
with linux)

WHAT I'VE DONE SO FAR
I've gone to www.iodbc.org and downloaded, untarred, and make'd the iODBC Driver manager v3.0.4 BETA
(http://www.iodbc.org/dist/libiodbc-3.0.4.tar.gz).

Doing this enabled me to compile my C++ client application (which makes use of the sql.h and sqlext.h headers). In addition I successfully linked the application.

The next thing I understand I had to do was obtain an oracle ODBC driver, which strangely enough Oracle seem to choose not to provide. I tried the openlink software page referenced from the iodbc page (http://www.openlinksw.com/). This is where I start to feel a little confused.

What I don't want is a database on my linux machine. All I want is the driver that permits me to talk to an Oracle database.

I tried installing a glibc2 driver, but I keep getting RPC: Unknown host errors even though the linux machine can quite happily see (ping) the database server. Thus I suspect I've done something wrong with the whole installation thing.

Anyway, if somebody has been through the pain and trial and error of all this before, I'd like to hear about it.

Thanks,
Peter Received on Sun Nov 05 2000 - 17:29:58 CST