B. Shannon

B. Shannon

  • 2k
  • 1
  • 4k

How can I solve the "could not load file or assembly 'ADODB'

May 4 2016 5:58 PM
I get, "*Solution to "Could not load file or assembly 'ADODB' or one of its dependencies. Access is denied"*" and found this link: https://blogs.msdn.microsoft.com/sayanghosh/2007/04/21/solution-to-could-not-load-file-or-assembly-or-one-of-its-dependencies-access-is-denied/  that supposedly has the solution, but it made no difference for me - I still get the same error. I gave full access to the user not only in the folder mentioned in that link (C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files) but also in my virtual directory where ADODB.dll resides (C:\CSPortalCode\csportal\Bin)
Am I barking up the wrong tree? I also gave Full access to the other account that did not have already have it, but that also made no diff. Now everybody on the "Security" tab for ADODB.dll has been granted Full Access, namely:
Authenticated Users
SYSTEM
Administrators (...)
Users (...)
Also, ADODB.dll *is* version 2.8, which is the version that is expected and is supposedly unloadable.
The err page has this warning:
"WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1", but trying to do so shows no such available setting. If I need to create it myself, where exactly - directly beneath the "\Microsoft" folder,or...???
The full err page is:
*Server Error in '/CPSPortal' Application.
Could not load file or assembly 'ADODB' or one of its dependencies. 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.IO.FileLoadException: Could not load file or assembly 'ADODB' or one of its dependencies. 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.
Assembly Load Trace: The following information can be helpful to determine why the assembly 'ADODB' could not be loaded.
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
Stack Trace:
[FileLoadException: Could not load file or assembly 'ADODB' or one of its dependencies. Access is denied.]
[FileLoadException: Could not load file or assembly 'ADODB, Version=2.8.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Access is denied.]
System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +416
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +166
System.Reflection.Assembly.Load(String assemblyString) +35
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +190
[ConfigurationErrorsException: Could not load file or assembly 'ADODB, Version=2.8.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Access is denied.]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +11327096
System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +388
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +232
System.Web.Configuration.AssemblyInfo.get_AssemblyInternal() +48
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +210
System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +76
System.Web.Compilation.CodeDirectoryCompiler.GetCodeDirectoryAssembly(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories, Boolean isDirectoryAllowed) +11316274
System.Web.Compilation.BuildManager.CompileCodeDirectory(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories) +185
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +551
[HttpException (0x80004005): Could not load file or assembly 'ADODB, Version=2.8.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Access is denied.]
System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +76
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +1012
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +1025
[HttpException (0x80004005): Could not load file or assembly 'ADODB, Version=2.8.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Access is denied.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +11421094
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +11294584
Version Information: Microsoft .NET Framework Version:2.0.50727.5485; ASP.NET Version:2.0.50727.5491*
Does it matter that the version differ, even if but only slightly, between .NET Framework and ASP.NET (by 0.006)?

Answers (1)