1 Reply Latest reply on Dec 14, 2012 8:23 AM by Christian.Shay -Oracle

    Problem on configuring Oracle ODBC Driver

    974845
      Hi
      I'm developping an application with .net framework and i wanted to use entity framework, and oracle as data base system, so i installed oracle 10g express edition.
      After that i wanted to install 64bits ODAC from here http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html,
      and it marked that it required the installation of oracle tools for visual studio first, i installed it from here http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
      Then i configured my TNS file as it indicated here http://www.tensixconsulting.com/2012/06/setting-up-an-oracle-odbc-driver-and-data-source/ ,
      in the step where i should add the user DSN i found as 'Oracle in ORAClient11g_home2' and i add it , but in the configuration i didn't found the TNS name service that i named on the tns file, it doesn't appear in the selection list. So i wrote it directly, the system demanded the user ID and the password, i wrote it and i had this error


      Unable to connect
      SQLState=08004
      [Oracle][ODBC][Ora] ORA-12154: TNS:could not resolve the connect identifier specified


      and i'm sure that i entred my Id and my passowrd correctly




      NB: When i was searchin the tnsnames file, i found 2 directory of client in the path 'C:\app\BAYREM\product\11.2.0' there are 'client_1' and 'client_2' i think that the first is for the oracle tools for visual studio and the second is for the 64bits ODAC


      Please i'm in hurry
      thx