SQLite Unable to load DLL 'SQLite.Interop.dll'

[SteveB_Help2]

Hi


I have written a small app using SQLite as an embedded database. I have the need to use views, so using this instead of SQL Compact

All works fine, as in I can run the app from VS, present the screen and grab all the data needed from the file in the application directory.

However, on publish I get the following exceptions. On installing via NuGet, everything seemed fine. Is there anything esle needed. I did try to add SQLite.Interop.dll' to the project but and used 'content' copy always. However, this did not work either.

Regards

Steve


************** Exception Text **************
System.TypeInitializationException: The type initializer for 'App1.bas_functions' threw an exception. ---> System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(SQLiteConfigOpsEnum op)
at System.Data.SQLite.SQLite3.StaticIsInitialized()
at System.Data.SQLite.SQLiteLog.Initialize(String className)
at System.Data.SQLite.SQLiteConnection..ctor(String connectionString, Boolean parseViaFramework)
at System.Data.SQLite.SQLiteConnection..ctor(String connectionString)
at App1.bas_functions..cctor()
--- End of inner exception stack trace ---
at App1.bas_functions.GetDataset1(String select_statement)
at App1.Main_Form.LoadCountermeasures()
at App1.Main_Form.Main_Form_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at Syncfusion.Windows.Forms.MetroForm.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at Syncfusion.Windows.Forms.MetroForm.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.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Continue reading...