in

SQLite and x64 Compile Issue

Last post 05-15-2008 5:14 AM by Yoma. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 02-12-2008 1:37 PM

    • ScSub
    • Top 75 Contributor
    • Joined on 02-12-2008
    • Posts 23

    SQLite and x64 Compile Issue

    Using SubSonic 2.1 Beta 1 and the SQLite ADO.NET bits on an x64 system.

     

    SubCommander fails to run with the version of System.Data.SQLite.dll that is included in the distribution. It appears that SubCommander was compiled "for any CPU", which breaks the x64<->x86 compatibility with SQLite. Setting the project build preference to "x86" lets sonic.exe run x64 system.

     

    The error that Fusion reports looks something like this:

     

    System.BadImageFormatException: Could not load file or assembly 'System.Data.SQLite....

     

    Hopefully there are enough key words in there that anyone looking for help via a web search will find this post. ;) 

  • 04-08-2008 12:50 PM In reply to

    • naveed
    • Not Ranked
    • Joined on 04-08-2008
    • Posts 2

    Re: SQLite and x64 Compile Issue

    I couldn't get 2.1 beta to work even after recompiling SubSonic as an x86 project. I even tried using the x64 SqLite.dll with "any CPU" and it still kept complaining. I was able to successfully use it with 2.0.3.
  • 04-21-2008 10:58 PM In reply to

    Re: SQLite and x64 Compile Issue

    I just tried SubSonic 2.1 Beta 3 on my x64 machine and it didn't work out of the box, either.  The site compiles fine, but when I run the website, I get errors.

    I referenced SubSonic.dll, and it automatically brought in the Enterprise Library dll files along with MySQL and SqLite.  Even without using any of the code, the site stopped working.

    Since I'm using SQL Server, I kept SubSonic.dll and deleted the other DLL files and everything worked fine.

    I pasted the entire error message I got below.

     

    Server Error in '/' Application.

    Could not load file or assembly 'System.Data.SQLite' or one of its dependencies. An attempt was made to load a program with an incorrect format.

    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.BadImageFormatException: Could not load file or assembly 'System.Data.SQLite' or one of its dependencies. An attempt was made to load a program with an incorrect format.

    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 'System.Data.SQLite' 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:

    [BadImageFormatException: Could not load file or assembly 'System.Data.SQLite' or one of its dependencies. An attempt was made to load a program with an incorrect format.]
    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) +465
    System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +181
    System.Reflection.Assembly.Load(String assemblyString) +42
    System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +190

    [ConfigurationErrorsException: Could not load file or assembly 'System.Data.SQLite' or one of its dependencies. An attempt was made to load a program with an incorrect format.]
    System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +3642952
    System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +402
    System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +155
    System.Web.Configuration.AssemblyInfo.get_AssemblyInternal() +36
    System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +235
    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) +2945079
    System.Web.Compilation.BuildManager.CompileCodeDirectory(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories) +204
    System.Web.Compilation.BuildManager.CompileCodeDirectories() +615
    System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +739

    [HttpException (0x80004005): Could not load file or assembly 'System.Data.SQLite' or one of its dependencies. An attempt was made to load a program with an incorrect format.]
    System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +79
    System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +2944472
    System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +1163

    [HttpException (0x80004005): Could not load file or assembly 'System.Data.SQLite' or one of its dependencies. An attempt was made to load a program with an incorrect format.]
    System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +2740375
    System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
    System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +2739988


    Version Information: Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434 

    Filed under:
  • 04-22-2008 2:19 PM In reply to

    Re: SQLite and x64 Compile Issue

    If you are just using SQLServer then you can try building the project in Release (SQL Server Only) Mode
    If I am I because I am I, and You are You because You are You, then I am I, and you are you. But If I am I because You are You, and You are You because I am I, then I am not I and You are not You. -Rabbi of Kotzk
  • 05-15-2008 5:14 AM In reply to

    • Yoma
    • Top 150 Contributor
    • Joined on 01-26-2008
    • Posts 12

    Re: SQLite and x64 Compile Issue

    I wonder if indeed it's possible to run sqlite with subsonic on x64, is there some trick? I don't know if the wrapper for sqlite even exists in x64?

    Is there some way to build your project in x64/x86 mode?

     

Page 1 of 1 (5 items)