2 Replies Latest reply on Jul 17, 2012 6:55 AM by 949675

    problem with connecting to Oracle database using Oracle ODBC Driver in .net


      I'm using following connection string:
      +connectionString="Driver={Oracle ODBC Driver};Server=someDb;Uid=useruidr;Pwd=password"+

      when I call method "Open" on "OdbConnection" I get following exception:
      +ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified+

      "someDb" is specified correctly in tsnames.ora,
      "...\client" and "...\client\bin" are added to PATH environmental variable
      ORACLE_HOME is set to "...\client"

      I have Oracle Client installed
      Operating system is Windows 7 32 bit

      When I change Driver to "Microsoft ODBC for Oracle" it works fine. However I want to use Oracle ODBC Driver


      Edited by: user10940554 on 16-Jul-2012 08:10