Asp.net Forum

Ask Question   UnAnswered
Home » Forum » Asp.net       RSS Feeds

Access Denied Error

  Asked By: Phil    Date: Mar 31    Category: Asp.net    Views: 1001

Can any one help me resolving the error when I trying to access Oracle 9i thru
my .net Application.
Access is denied.
Description: An unhandled exception occurred during the execution of the current
web request. Please review the stack trace for more information about the error
and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Access is denied.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can be
identified using the exception stack trace below.
Stack Trace:

[OleDbException (0x80070005): Access is denied.]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) +23
System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr)
+107 System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
+304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
+77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
NewProject1.Data.OleDbDao.RunSqlImpl(String sql) +99
NewProject1.Data.DBUtility.CheckUser(String userName, String userPassword) +85
NewProject1.Login.Login.Login_DoLogin(Object sender, EventArgs e) +112
System.Web.UI.HtmlControls.HtmlInputButton.OnServerClick(EventArgs e) +108
aisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl,
String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277



4 Answers Found

Answer #1    Answered By: Flynn Jones     Answered On: Mar 31

Do you have the database user name and password correctly in your connection
string, if you are using integrated authentication it will use
MACHINENAME\ASPNET which is a localaccount

Answer #2    Answered By: Kanchan Ap     Answered On: Mar 31

Can you give us an example of your connection string? Just change the names.

Answer #3    Answered By: Haya Yoshida     Answered On: Mar 31

Connection String is :

strconnect="Provider=MSDAORA.1;Password=tiger;User ID=scott; Data
Source=tba;Persist Security Info=True"

and Error is :

Error Accessing Database.
Oracle client and networking components were not found. These components are
supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later
client software installation. Provider is unable to function until these
components are installed.
Microsoft OLE DB Provider for Oracle

Answer #4    Answered By: Geneva Morris     Answered On: Mar 31


strconnect= " Provider=MSDAORA.1; server=(local);Password=tiger;User
ID=scott; Data Source=tba"

Replace LOCAL with the server name if the server is not on the same machine
as the application

Didn't find what you were looking for? Find more on Access Denied Error Or get search suggestion and latest updates.