Activity overview
Latest activity by eg4325
I was having a similar problem with the Visual Studio 2017 (VS 2017) extension. The error was: ERROR DatabaseObjectIndexer - Exception while indexing database {database name}: System.DllNotFoundException: 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(String className) at System.Data.SQLite.SQLiteConnection..ctor(String connectionString, Boolean parseViaFramework) at System.Data.SQLite.SQLiteConnection..ctor(String connectionString) at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.EnsureConnectionOpen() at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.CreateCommand() at RedGate.SQLSearch.Indexing.SQLite.DatabaseObjectStorage.Initialise() at RedGate.SQLSearch.Indexing.DatabaseObjectIndexer.Index() The SQL Search version was 3.2.4.2262. I noticed the extension install directory did not have the referenced SQLite.Interop.dll. The install directory was "C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\Common7\IDE\Extensions\001ss942.rgs". I ended up installing the SQL Server Management Studio (SSMS) SQL Search version (also 3.2.4.2262). I then copied the SQLite.Interop.DLL file (version 1.0.110.0) from "C:\ProgramData\Red Gate\SQL Search\Source" to the Visual Studio directory referenced above. This solved my problem. / comments
I was having a similar problem with the Visual Studio 2017 (VS 2017) extension. The error was:ERROR DatabaseObjectIndexer - Exception while indexing database {database name}: System.DllNotFoundExce...