Request a topic or
contact an Arke consultant
404-812-3123
Sitecore

Arke Systems Blog

Useful technical and business information straight from Arke.

About the author

Author Name is someone.
E-mail me Send mail

Recent comments

Archive

Authors

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2024

Debugging with Visual Studios (SQLite error)

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=1.0.48.0, 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.


Tags: , , , ,
Categories: Sitecore
Posted by Nicole Rodriguez on Monday, April 12, 2010 12:37 PM
Permalink | Comments (0) | Post RSSRSS comment feed

Web Form for Marketers

For those just downloading the installer, check inside your downloaded file first (and ALWAYS for future packages) and be sure that there is only one zip inside called 'package.zip'.  Do not unzip that file.  Sometimes they wrap the package in another zip for downloading off their website.  If you do not catch a double zipped package, you bring doom and reinstall for your application.  Follow the instructions on installing packages as suggested on www.sdn.sitecore.net .  After installing, it is not a finished out of the box product.  Follow the instructions below.

To submit forms (Associated Error: ‘We experience a technical difficulty while processing your request. Your data may not have been correctly saved.’) 

-          Open SQL Server and attach database located in Website/Data/Sitecore_WebForms.mdf

-          Open forms.config file in Website/App_Config/Include/forms.config

-          Uncomment the mssql connection string and add the proper fields

-          Open connecitonstrings.config in Website/App_Config/Connectionstrings.config

-          (The magic.) Add this to your config: <add name="remoteWfmService" connectionString="url=http://localhost/sitecore%20modules/shell/Web%20Forms%20for%20Marketers/Staging/WfmService.asmx;user=admin;password=b;timeout=60000"/>

-          Test.


Categories: Sitecore
Posted by Nicole Rodriguez on Monday, April 12, 2010 12:31 PM
Permalink | Comments (0) | Post RSSRSS comment feed