[sqlite-dev] Unable to load DLL 'SQLite.Interop.dll' run time error

[shamsa abid]

Dear All,

I am using Windows 7 on a 64 bit system and Visual Strudio 2010. I am getting the following error when I connect to SQLite. 

Unable to load DLL 'SQLite.Interop.dll': The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail. 

I have tried troubleshooting by using the following links:

http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki

http://system.data.sqlite.org/index.html/tktview/54e52d4c6f?plaintext

Below is the exception detail:

System.DllNotFoundException was unhandled

  Message=Unable to load DLL 'SQLite.Interop.dll': The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail. (Exception from HRESULT: 0x800736B1)

  Source=System.Data.SQLite

  TypeName=""

  StackTrace:

       at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(SQLiteConfigOpsEnum op)

       at System.Data.SQLite.SQLite3.StaticIsInitialized()

       at System.Data.SQLite.SQLiteLog.Initialize()

       at System.Data.SQLite.SQLiteConnection..ctor(String connectionString, Boolean parseViaFramework)

       at System.Data.SQLite.SQLiteConnection..ctor(String connectionString)

       at System.Data.SQLite.SQLiteConnection..ctor()

       at MobileSyncApp.DAL.HHTDAL.InitializeDatabase() in E:\NPDMS\MobileApp Code (NEW)\Sourcecode\DAL\HHTDAL.cs:line 52

       at MobileSyncApp.DAL.HHTDAL.getConfigValue(String key) in E:\NPDMS\MobileApp Code (NEW)\Sourcecode\DAL\HHTDAL.cs:line 351

       at MobileSyncApp.BO.SyncBO.getOBName() in E:\NPDMS\MobileApp Code (NEW)\Sourcecode\BO\SyncBO.cs:line 74

       at MobileSyncApp.Form1.comboBox1_SelectionIndexChanged(Object sender, EventArgs e) in E:\NPDMS\MobileApp Code (NEW)\Sourcecode\HHTSynch.cs:line 165

       at System.Windows.Forms.ComboBox.OnSelectionChangeCommitted(EventArgs e)

       at System.Windows.Forms.ComboBox.OnSelectionChangeCommittedInternal(EventArgs e)

       at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)

       at System.Windows.Forms.ComboBox.WndProc(Message& m)

       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

       at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

       at System.Windows.Forms.UnsafeNativeMethods.SendMessage(HandleRef hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)

       at System.Windows.Forms.Control.SendMessage(Int32 msg, IntPtr wparam, IntPtr lparam)

       at System.Windows.Forms.Control.ReflectMessageInternal(IntPtr hWnd, Message& m)

       at System.Windows.Forms.Control.WmCommand(Message& m)

       at System.Windows.Forms.Control.WndProc(Message& m)

       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

       at System.Windows.Forms.ContainerControl.WndProc(Message& m)

       at System.Windows.Forms.Form.WndProc(Message& m)

       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

       at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

       at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)

       at System.Windows.Forms.NativeWindow.DefWndProc(Message& m)

       at System.Windows.Forms.Control.DefWndProc(Message& m)

       at System.Windows.Forms.Control.WmCommand(Message& m)

       at System.Windows.Forms.Control.WndProc(Message& m)

       at System.Windows.Forms.ComboBox.WndProc(Message& m)

       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

       at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

       at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Application.Run(Form mainForm)

       at MobileSyncApp.Program.Main() in E:\NPDMS\MobileApp Code (NEW)\Sourcecode\Program.cs:line 17

       at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)

       at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)

       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()

       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)

       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

       at System.Threading.ThreadHelper.ThreadStart()

  InnerException: 

[Joe Mistachkin]

shamsa abid wrote:
>
> Unable to load DLL 'SQLite.Interop.dll': The application has failed to
start because
> its side-by-side configuration is incorrect. Please see the application
event log or
> use the command-line sxstrace.exe tool for more detail.
>

This error message typically indicates that the Microsoft Visual C++ Runtime
is not
installed or is the wrong version. Please see the following page for the
necessary
downloads:

https://support.microsoft.com/kb/2019667

--
Joe Mistachkin

_______________________________________________
sqlite-dev mailing list
sqlit...@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev

[shamsa abid]

I followed the instructions on this link to solve my problem

http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/

Installing ADO.Net provider for SQLite did the trick.