List,
Oracle is installed on a Linux Server. I have been trying to find out the version number of odbc installed on the server. However, I am not able to find odbc manager to find out the version of the driver(s) installed.
I have tried searching the web, but cannot find a definitive answer. Can somebody help me / direct me as to where I should be looking?
-- Roshan Baladhanvi
Greetings,
Distribution details please.
On Sat, Dec 25, 2010 at 7:05 PM, Roshan kubunturos@gmail.com wrote:
List,
Oracle is installed on a Linux Server. I have been trying to find out the version number of odbc installed on the server. However, I am not able to find odbc manager to find out the version of the driver(s) installed.
rpm should help in redhat and apt should be your deb-friend
Regards,
Rajagopal
2010/12/25 Roshan kubunturos@gmail.com:
Oracle is installed on a Linux Server. I have been trying to find out the version number of odbc installed on the server. However, I am not
ODBC is a client-side API. You install ODBC Manager and the database driver (in this case, Oracle) on the client machines that want to access the database server.
Binand
Binand,
On Mon, Dec 27, 2010 at 12:50 PM, Binand Sethumadhavan wrote:
Oracle is installed on a Linux Server. I have been trying to find out the version number of odbc installed on the server. However, I am not
ODBC is a client-side API. You install ODBC Manager and the database driver (in this case, Oracle) on the client machines that want to access the database server.
Thanks for figuring out some 50% of what I had intended to say despite writing almost-like an incomplete email. I did not want to write such an email but I think I was in a hurry just to know a solution. My apologies.
So, to elaborate further Oracle 10g is installed on RHEL 5.4 and this machine acts as a database server. An application (J2EE) connects to this database, where the application itself is on another RHEL 5.4 server.
Now, there's a different application (haven't been informed which tech. stack) wants to access the same database and connects via ODBC driver (I do not the details of how it does it; probably via a DSN).
So the question is, if the application is on Linux too (RHEL / Fedora) how can one find the version of the driver?
I'm sorry if the question still sounds incomplete but this all that I know about the question.
-- Roshan Baladhanvi
2010/12/27 Roshan kubunturos@gmail.com:
So, to elaborate further Oracle 10g is installed on RHEL 5.4 and this machine acts as a database server. An application (J2EE) connects to this database, where the application itself is on another RHEL 5.4 server.
Let us call these Server A and Server B, respectively. Server B connects to Server A using (typically) one of JDBC or Hibernate.
Now, there's a different application (haven't been informed which tech. stack) wants to access the same database and connects via ODBC driver (I do not the details of how it does it; probably via a DSN).
Let us call this Server C. As you say, it will connect to Server A using ODBC.
So the question is, if the application is on Linux too (RHEL / Fedora) how can one find the version of the driver?
Tried rpm -qa | grep -i odbc ?
The "standard' Unix ODBC suite is called (somewhat unimaginatively, I should say) UnixODBC - www.unixodbc.org.
Basically, all RDBMS have some means by which applications can connect to them; Postgres' is (used to be?) a library called libpq. You use the API provided by libpq to connect to Postgres in your application.
This of course, has the problem that if you change the DB for any reason, then you need to rewrite all your code. So solutions like ODBC (and its Java counterpart, JDBC) emerged - your application will call an intermediate layer ("middleware", if you like), which will translate the query into the format accepted by the database. So, in this case you'd have ODBC calls in your application, and a Postgres ODBC driver will do the work of connecting to the database and executing your queries. If you change the database, all you need to do is to change the driver to that of the new database (and update configuration); no code rewriting is necessary.
So ODBC solves a problem in non-Java world, and JDBC does the same in Java world. Then you have ODBC to JDBC gateways and also ODBC - ODBC gateways. There's an ODBC driver for most databases, and also to CSV files, spreadsheets and to even things like NNTP articles. :-)
Binand
On Mon, Dec 27, 2010 at 9:52 PM, Roshan kubunturos@gmail.com wrote:
So the question is, if the application is on Linux too (RHEL / Fedora) how can one find the version of the driver?
You can use whatever version of Driver that Application in known to work
with.
When app process is launched, LD_LIBRARY_PATH should point to .so files for:
1. ODBC Libs 2. Oracle's ODBC driver
This way you need not worry about which version is already installed. You just need to specify that Linux Ditro details (Glibc version , X86 or X64) to get desired driver and tweak launch shell scripts for the App to include that driver.
-Shamit
On Sat, Dec 25, 2010 at 7:05 PM, Roshan kubunturos@gmail.com wrote:
List,
Oracle is installed on a Linux Server. I have been trying to find out the version number of odbc installed on the server. However, I am not able to find odbc manager to find out the version of the driver(s) installed.
I have tried searching the web, but cannot find a definitive answer. Can somebody help me / direct me as to where I should be looking?
With any query for help it is useful to provide the following information:
(a) Distro name (b) Distro version (c) x86 or amd64
Additionally, for performance related issues (e) RAM (f) CPU (g) Network speed
etc.
HTH -- Arun Khan
On 25 December 2010 19:05, Roshan kubunturos@gmail.com wrote:
Oracle is installed on a Linux Server.
Oracle has some tutorials for fedora , RHEL , ubuntu,debian,centos etc checkout http://wiki.oracle.com/page/Installfest+Community
Regards, Pavithran
Hi,
This worked for me.
http://www.oracle.com/technetwork/articles/technote-php-instant-084410.html
-
Ameya Pandit -
Arun Khan -
Binand Sethumadhavan -
pavithran s -
Rajagopal Swaminathan -
Roshan -
Shamit Verma