DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

949675Jul 16 2012 — edited Jul 17 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2012

Added on Jul 16 2012

#odbc, #oracle, #windows-and-net

2 comments

3,112 views