I’ve run into a reoccurring error that only pushes to the surface while debugging. The following error:
Could not load file or assembly 'System.Data.SQLite, Version=220.127.116.11, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. An attempt was made to load a program with an incorrect format.
Is a result of IIS and the windows box trying to run 32 vs 64 bit versions of the application and of the sqlLite.dll. There are two dlls involving sqlLite. One is System.Data.SQLite, the other System.SQLite. If you don’t require SQLite in your project, remove it or rename it from a .dll extension. See post for Web Forms for Marketers on how SQLite might affect you. If you must use SQLite, it is recommended that you download the correct version of the dll from here: http://www.sqlite.org/download.html
**There have been issues with people running the application after downloading the correct 64 version of the dll and running sitecore as a 64 bit application. Be sure you have .NET SP 1 installed on your VM or other.