ADODB.NET and "Access Denied"

From: ASP.Confused (anonymous_at_)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 16:04:30 -0400

I have an ASP.NET page writtein in VB that uses ADODB. I just had to
force-install MDAC 2.8 after I tried to rollback to 2.6 (my web host uses
this, and I wanted to be compatible with them.) I had to manually install
all of the ODBC drivers and the rest of the DLL's, and now I am getting
"Access is Denied" errors on any page that uses ADODB.

How do I fix it? I already gave the ODBC drivers in the folders in
"c:\program files\common files\system\" full access rights for both IUSR
accounts and the ASPNET account.

Here is the output of the error:

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.UnauthorizedAccessException: Access is denied.

ASP.NET is not authorized to access the requested resource. Consider
granting access rights to the resource to the ASP.NET request identity.
ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
Network Service on IIS 6) that is used if the application is not
impersonating. If the application is impersonating via <identity
impersonate="true"/>, the identity will be the anonymous user (typically
IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET write access to a file, right-click the file in Explorer,
choose "Properties" and select the Security tab. Click "Add" to add the
appropriate user or group. Highlight the ASP.NET account, and check the
boxes for the desired access.

Source Error:

Line 1: <script language="VB" runat="server">
*** Line 2: dim oConn as ADODB.Connection = new ADODB.Connection()
Line 3: </script>
Line 4: <%

Relevant Pages

  • Re: Word 2003 and DotNet
    ... You could give enough priveleges to asp.net account though I don't recommend ... reports in word programmatically directly in a Word document. ... If the application is impersonating via <identity ... IUSR_MACHINENAME) or the authenticated request user. ...
    (microsoft.public.dotnet.general)
  • Where is the built-in ASP.NET account?
    ... granting access rights to the resource to the ASP.NET request identity. ... If the application is impersonating via <identity ... I then found the following to try to recreate the ASP.NET account using the ...
    (microsoft.public.dotnet.framework.aspnet)
  • System.UnauthorizedAccessException //got stuck
    ... added this account to all admin groups. ... granting access rights to the resource to the ASP.NET request identity. ... Network Service on IIS 6) that is used if the application is not ... If the application is impersonating via <identity ...
    (microsoft.public.inetserver.iis.security)
  • System.UnauthorizedAccessException //got stuck
    ... added this account to all admin groups. ... granting access rights to the resource to the ASP.NET request identity. ... Network Service on IIS 6) that is used if the application is not ... If the application is impersonating via <identity ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Sample Logon Script
    ... > Re-entered push account and here is some of the CCM.log ... > Submitted request successfully SMS_CLIENT_CONFIG_MANAGER ... > name "ZRWKSHYMAN", in queue "Processing". ... > ---> Trying each entry in the SMS Client Remote ...
    (microsoft.public.sms.admin)
Quantcast