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
Hi,

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.

[ProgramFilesFolder][Manufacturer]\[ProductName]\x64\SQLite.Interop.dll
[ProgramFilesFolder][Manufacturer]\[ProductName]\x86\SQLite.Interop.dll
[ProgramFilesFolder][Manufacturer]\[ProductName]\MyAppAssembly.dll

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: 14129
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.

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