Solved

How do I verify the Oracle ODBC driver version?

Posted on 2013-11-08
6
587 Views
Last Modified: 2013-11-08
Hi,

I am having an issue with an ODBC driver, and I am trying to determine what version the Oracle ODBC driver is. I asked the tech person to install a patch to get it to v10.2.03, but when I go to the driver, and click on help, it is still saying that it is version 10.1.0.2.0 on the top ribbon. Is there another location that I can verify that this patch has been installed, and see the true version of the driver?

Thanks,

Brian
0
Comment
Question by:Whah
  • 3
  • 3
6 Comments
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 39634456
Yes, in "Windows Explorer" (or "My Computer", not: "Internet Explorer") navigate to your "Oracle_home" folder, then go to the "\inventory\ContentsXML" directory under that and open the "comps.xml" file with Word or a text editor and do a search for "VER" (in upper case).  That will show you the version of the Oracle software that you have installed.

If you don't know where your "Oracle_home" directory is, run "regedit", and go to: "HkeyLocalMachine, Software, Oracle".  Look for keys like: "Home0", "Home1", etc. or: "Key_Ora10g..." and look at the value for "ORACLE_HOME".  That should indicate a physical disk location like "C:\..." or possibly a directory on a network drive that you have access to.
0
 

Author Comment

by:Whah
ID: 39634529
Thank you, Mark. So simply the oracle client version will be the version of the ODBC driver as well. It appears in the screen shot that the v10.0.2.0.3 patch was not installed correctly/successfully if it is still showing client version 10.2.0.1.0. Correct?

Oracle version
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 39634619
That's what it looks like to me.  I admit that I haven't looked in this file very often to confirm a version number after applying a patch, but I would expect the latest patch version number to be reflected here.

Another option would be to start the Oracle installer (that got installed somewhere in your Oracle_home when your oracle software was installed) and have it display the version(s) of Oracle software that are installed.  The Oracle installer can do that without changing anything.  You may have an icon for the Oracle installer somewhere in your Start menu.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Whah
ID: 39634742
Ok, thanks again. I see a "Universal Installer." Would that be the one?
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 39634825
Yes.  If you launch that, it should give you the option to see what version(s) you have installed now.
0
 

Author Closing Comment

by:Whah
ID: 39634890
Thank you, Mark. I really appreciate your help.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Single ERP VS muttiple Application or Systems 6 64
null value 15 94
unable to get sorting resultset 15 68
Read only access to a Procedure in oracle? 4 48
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now