This discussion is archived
2 Replies Latest reply: Jul 16, 2012 11:55 PM by 949675 RSS

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

949675 Newbie
Currently Being Moderated

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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points