ODBC DSN to connect Oracle

prashantSum's Avatar
Contributor
Hi ,

I use ODBC DSN to connect Oracle.

string ConnString ="DSN=OracleTest;UID=webstore;PWD=webstore";
OdbcConnection connection = new OdbcConnection(newConnString);
connection.Open();

when I setup the DSN in windows ODBC Datasource manager, the test
connection was successful, but when use in asp.net code,

I got the following errors:

"ERROR [IM003] Specified driver could not be loaded due to system error 5 (Oracle in OraClient10g_home4)."

Does anyone have some idea about this error?
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
You are passing newConnString as the parameter where as it should be ConnString
prashantSum's Avatar
Contributor
sorry that's actually only a spelling mistake,

the proper code is given below,

string ConnString ="DSN=OracleTest;UID=webstore;PWD=webstore";
OdbcConnection connection = new OdbcConnection(ConnString);
connection.Open();

so still I am getting the same error

"ERROR [IM003] Specified driver could not be loaded due to system error 5 (Oracle in OraClient10g_home4)."
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
By default, anonymous access to ASP applications uses the local IUSR_COMPUTERNAME account and ASP.NET applications use the local ASPNET account.

Try adding IUSR_COMPUTERNAME account or the ASPNET account to the Runtime Users group and restart the IIS Service