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.***.com/ ).

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

Why do you want to run ODBC in a UNIX environment? If you use Oracle proc,
you could embed real SQL inside your code and use SQL*Net to connect to any
database on your network. This would also be a more efficient technique for
accessing your data.

Regards,

Kevin.

--
Justin Cave - Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of
Oracle Corporation.

Sent via Deja.com http://www.deja.com/
Before you buy.