Oracle Connection over ODBC

andreas domevscek

12y1.6k.NET

Hello,

I want to connect with oracle database.

my Connection String in web.config:

connectionStrings>

in webapp i have

string CS = ConfigurationManager.ConnectionStrings["ConStrOrcl"].ConnectionString;

OdbcConnection con = new OdbcConnection(CS);

OdbcCommand cmd = new OdbcCommand ("select Id, CityName, Country from nha.tblCity", con);

con.Open();

but when con.open gives me an error

ERROR [IM002] [Microsoft][ODBC-stuurprogrammabeheer] De naam van de gegevensbron is niet gevonden en er is geen standaardstuurprogramma opgegeven

Can someone give me the clue?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arunava Bhattacharjee12y ago
Accepted answer
Hey, use con.Open() before passing it to cmd constructor. If this solves your problem then mark it as accepted, otherwise provide the error details in english, didn't really understand the error message :)
Arunava Bhattacharjee12y ago
This error comes when we create ODBC driver under "User DSN" because DSN created under "User DSN" can be used by same user. But when we host application on IIS than application runs under default ASP.NET identity. To remove this error just shift your DSN from "User DSN" to "System or File DSN"

Found solution on http://aspnet.blogershub.com/Archive/2013/11/ERROR-IM002-Data-source-name-not-found-and-no-default-driver-specified

Mark the answer as accepted if it resolves your problem.