3 Replies Latest reply: Jan 11, 2012 2:44 PM by 743319 RSS

    Can't see the odbc driver in windows 7

    909543
      hallo everybody
      I've just installed the oracle instant client 11.2.0.2.0 on a windows 7 machine. when i execute the file odbc_install the returned prompt is "Oracle ODBC Driver is installed successfully.". then when i go to system -> administration -> data sources (odbc) i can't see no oracle odbc driver. what wrong?

      Edited by: 906540 on 07.01.2012 11:37
        • 1. Re: Can't see the odbc driver in windows 7
          868669
          i'm the user 906540 and the following pic is what i can see in odbc-data sources and drivers:

          http://javapup.i-networx.de/oracleodbc.gif

          is that ok?

          Edited by: tuttle64 on 07.01.2012 13:57

          Edited by: tuttle64 on 07.01.2012 13:58

          Edited by: tuttle64 on 07.01.2012 13:59
          • 2. Re: Can't see the odbc driver in windows 7
            868669
            yes it's ok. i could set up a new user dns and inside this dns the Test Connection was successful.
            • 3. Re: Can't see the odbc driver in windows 7
              743319
              Great you have figured it out finally. Just thought you should know that there is a bug in 11gR2 client and because of that Oracle driver version is shown as 11.1.0.7 instead of 11.2.0.2. This can be confusing 6 months or a year later down the road if you wanted to go back and upgrade your client to, let's say' 12g. To fix this, there is a patch available from Oracle metalink, patch id is p11731183 for 32bit and p11731184 for 64bit windows. This bug is mentioned in 1308617.1