Connect to SqLite DB - System.Data.SQLite​ v2


Author
Message
gjain
gjain
New Member (2 reputation)New Member (2 reputation)New Member (2 reputation)New Member (2 reputation)New Member (2 reputation)New Member (2 reputation)New Member (2 reputation)New Member (2 reputation)New Member (2 reputation)
Group: Forum Members
Posts: 1, Visits: 4
I have followed the instructions on connecting to SqlLite DB
1. Added System.Data.SQLite.dll to "AppData\Local\LogViewPlus\DbProviders" folder. I downloaded the dll from  https://www.nuget.org/packages/System.Data.SQLite/2.0.2#supportedframeworks-body-tab
2. Enabled custom plugins
3. Restarted LogViewPlus

But I still get the error "Unable to resolve provider for type: SQLite"

Also tried the "Program Data" route. But same issue.
Edited Last Week by LogViewPlus Support
LogViewPlus Support
LogViewPlus Support
Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)Supreme Being (12K reputation)
Group: Moderators
Posts: 1.3K, Visits: 4.4K
Hi GJain,

Thanks for bringing this issue to our attention.  It took a little research to figure out what was going on.

Previously, LogViewPlus was tested and working with System.Data.SQLite v1.0.119.  For this release, you need to put the System.Data.SQLite.dll file into the %AppData%\LogViewPlus\DbProviders directory and that should be job done.

In the new System.Data.SQLite v2 release, things have changed a bit.  The communication layer is PInvoke rather than Interop, so you will need to provide a e_sqlite.dll file manually.  This is packaged for you in the sourcegear.sqlite3 nuget package.

Be sure to use the correct e_sqlite.dll version which is win-x64/native:



Place both files into the DbProviders directory:



Finally, be sure the dlls are not blocked.  If visible, you will need to check this box and select 'OK'.



Hope that helps,

Toby

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Login

Explore
Messages
Mentions
Search