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

Legend

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