ODBC client access from Linux for Oracle Database 
Author Message
 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.***.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



Wed, 18 Jun 1902 08:00:00 GMT
 ODBC client access from Linux for Oracle Database

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.



Fri, 25 Apr 2003 14:59:57 GMT
 ODBC client access from Linux for Oracle Database


Quote:
> 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.

Just to clarify, Oracle doesn't provide an ODBC driver for any non-
Windows platform.  Other vendors may provide drivers for an Oracle
database that work on a Linux client.

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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. How to distribute an Access Database Client with an ODBC connection to Oracle

2. informix IDS on Linux and ODBC access from Client SDK

3. Oracle Client for Linux and Oracle Client for NT -- Help

4. ODBC database access WITHOUT ODBC software on client?

5. Help: Linux client access to Sparc Oracle 7

6. Linux client access to Oracle server?

7. Reading from a Oracle Database on a Linux Client

8. Accessing a 32bits Database with a 16bits client using ODBC

9. Oracle 8.0.5 client on linux connecting to Oracle 7.3.4 on Solaris

10. ODBC *clients* for Linux?

11. RDO accessing IBM Client Access 95 ODBC Source

12. AS/400 Client Access - ODBC Access Problem


 
Powered by phpBB® Forum Software