Activity overview
Latest activity by JArmando
Vivan said:
I was having this same issue. I resolved it by replacing the System.Data.SQLite.dll in C:\ProgramData\Red Gate\SQL Search\Source with the older version (1.0.85.0, copied from SQL Prompt 9 folder, C:\Program Files (x86)\Red Gate\SQL Prompt 9). It looks like it's likely due to the multiple versions of SQLite being used and the x64/x86 versions not being published appropriately for the new version (1.0.110.0) BTW, this did not work when I replaced it with 1.0.109.0 - my guess it has to do with the changes to the library pre-loader introduced in 1.0.91.0. I now know that this happens because SQL Prompt uses version 1.0.85.0 and Search uses 1.0.110.0, but tries to use the Prompt version of SQLite.Interop.DLL. So as long as both Prompt and Search use the same version, it will work fine. Looks like an integration testing problem! Prompt and Search both work fine alone, but if you install both of them then Search breaks.
Very nice solution, thanks full La solucion consiste en copiar el archivo System.Data.SQLite.dll de la ruta "C:\Program Files (x86)\Red Gate\SQL Prompt 6" ( esta ruta es en la que tienen instalado el SQL Prompt) y pasarla a la ruta "C:\Program Files (x86)\Red Gate\SQL Search" ( esta ruta es en la que tienen instalado el SQL Search) y reinician los servicios del sql server o reinician la pc. / comments
Vivan said:
I was having this same issue. I resolved it by replacing the System.Data.SQLite.dll in C:\ProgramData\Red Gate\SQL Search\Source with the older version (1.0.85.0, copied from SQL ...