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.

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

Thanks. This worked.
I have a follow-up question. My database has two timestamps column (TimeStamp_UTC and TimeStamp_Local). However, LogViewPlus' column mapping only shows the first timestamp column. How can I make it recognize both of them.
Another issue is my timestamps are in Julian format and on "Validate" action I get this error "INVALID: String was not recognized as a valid DateTime."

How do I resolve both of these limitations?

Glad that helped.  Thanks for letting me know.

Regarding the remaining issues, it is difficult for me to know what the issue is without seeing the underlying data.  When you add your database connection, you will see a tab at the top for "Column Mappings".  You will need to play with these settings for best results. 

LogViewPlus only supports one timestamp column (for date filtering and merging).  The other column may need to be imported as a string.

Hope that helps,

Toby