Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


How do I verify the Oracle ODBC driver version?

Posted on 2013-11-08
Medium Priority
Last Modified: 2013-11-08

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 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?


Question by:Whah
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
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.

Author Comment

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. patch was not installed correctly/successfully if it is still showing client version Correct?

Oracle version
LVL 35

Accepted Solution

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.
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.


Author Comment

ID: 39634742
Ok, thanks again. I see a "Universal Installer." Would that be the one?
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.

Author Closing Comment

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

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

715 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