In my VSTO app I use sqlite fts5 module. On the development machine the app works OK, but when I publish it and try to execute SELECT query - NOTHING HAPPENS (even no exception is thrown!)!
Here is my code:
try
{
using (SQLiteConnection connection = new SQLiteConnection(connectionstring))
{
using (SQLiteDataAdapter adapter = new SQLiteDataAdapter("SELECT * FROM Categories order by Name", connection))
{
adapter.Fill(Globals.ThisAddIn.Categories_Table); //here is the line where the code execution goes to infinity
}
}
}
catch (SQLiteException ex)
{
MessageBox.Show($"{ex.Message}\nError code: {ex.ResultCode}\nHResult: {ex.HResult}\nSource: {ex.Source}\nStack trace:\n{ex.StackTrace}", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show($"{ex.Message}\nHResult: {ex.HResult}\nSource: {ex.Source}\nStack trace:\n{ex.StackTrace}", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Whether Nuget System.Data.SQLite.Core.FTS5 package is installed or not, it's not working on the client's machine.
I use "Any CPU" configuration and System.Data.SQLite nuget package. The development and client machines both use Office 64-Bit.
Is there any solution to make FTS5 module work on the client's machine?
