Custom Action Error in loading SQLite

Add-in Express™ Support Service
That's what is more important than anything else

Custom Action Error in loading SQLite
Soe Thu Aung

Posts: 15
Joined: 2015-04-14

I'm trying to add code to create/modify database structure in custom action. Custom action alone is working well, have tested with simple log. But when I add code to use SQLite dll, throwing error. I'm using C# Custom Action Project template and referencing my data layer dll inside my custom action code which is using SQLite dll. So full path will be like this "Custom Action-->Data Layer DLL-->SQLLite". Issue is custom action code unable to load SQLite.Interop.dll. Actually SQLite.Interop.dll is already under installation folder. Here is my installation folder structure.


Following is the details error message.

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()
at System.Data.SQLite.SQLiteConnection..ctor(String connectionString, Boolean parseViaFramework)
at System.Data.SQLite.SQLiteConnection..ctor(String connectionString)
at PLD.KM.Data.SQLiteService..ctor()
Posted 07 Jul, 2015 22:10:46 Top
Andrei Smolin

Add-in Express team

Posts: 18219
Joined: 2006-05-11
Hello Soe,

I'm sorry, we cannot help you with this issue as it doesn't relate to using any of our products. I suppose this relates to placing interops in x86 and x64 subfolders.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 08 Jul, 2015 06:19:50 Top
Soe Thu Aung

Posts: 15
Joined: 2015-04-14
Hi Andrei,

Thanks anyway.

Soe Thu Aung
Posted 08 Jul, 2015 21:00:18 Top