2 Replies Latest reply: Jul 17, 2012 1:55 AM by 949675 RSS

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

    949675
      Hello,

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

      regards
      Piotr

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