How do I verify the Oracle ODBC driver version?

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
WhahAsked:
Who is Participating?
 
Mark GeerlingsDatabase AdministratorCommented:
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
 
Mark GeerlingsDatabase AdministratorCommented:
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
 
WhahAuthor Commented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
WhahAuthor Commented:
Ok, thanks again. I see a "Universal Installer." Would that be the one?
0
 
Mark GeerlingsDatabase AdministratorCommented:
Yes.  If you launch that, it should give you the option to see what version(s) you have installed now.
0
 
WhahAuthor Commented:
Thank you, Mark. I really appreciate your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.