Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How do I verify the Oracle ODBC driver version?

Posted on 2013-11-08
6
Medium Priority
?
624 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 2000 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 

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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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
Suggested Courses

876 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