Query an Oracle DB from Linux

[Adamhemo]

Hi all,

Couls someone tell me how to Query an Oracle 8 DB from Linux? to be more specific I am trying to do so from OpenOffice spreadsheet package that is installed with Red Hat 8.0.

From my Windows PCs, the operation is simple, I have to install the SQLNet easy, configure the server location, open up Ms-Query in Excell, select the Oarcle ODBC driver for Microsoft, and I am there ...

Can some one tell me how to do the same in OpenOffice ??

Thanks

Adam

 

[Turkbear]

Hi,
If you have the Oracle client installed and properly configured on your Linux box,and a Unix/Linux set of ODBC drivers, it should be pretty much the same process...Check the docs for OpenOffice to see how to use ODBC with it..

 

[Adamhemo]

Thanks for replying, I have not been able to find the Oracle client on Oracle website, do you have a direct link to it by any chance ?

Adam

 

[Turkbear]

Hi,
The v9 is on technet:

http://otn.oracle.com/software/products/oracle9i/content.html

( You will need to register - its free and very valuable site)..
Older versions are also there, but you will need to search for them...

 

[Adamhemo]

Ok, I have downloaded and Installed the Oracle Client for Linux and was able to connect to my DB from SQLPlus, so I know this part is working

It has been a nightmare trying to find an Oracle ODBC driver for linux, I found one and downloaded the eval copy of it (made by Easyoft) but still not sure what to do next !!!

I have noticed that in some of the searches I have done, many people are talking about JDBC as an alternative, Can someone tell me more about