Activity overview
Latest activity by Vivan
evanfantr said:
ejenkins said:
Unfortunately I have no System.Data.SQLite.dll file in C:\Program Files (x86)\Red Gate\SQL Search 3 so this doesn't work for me.
Same here. Please send an update for the extension.
See my above message. / comments
evanfantr said:
ejenkins said:
Unfortunately I have no System.Data.SQLite.dll file in C:\Program Files (x86)\Red Gate\SQL Search 3 so this doesn't work for me.
Same here. Please send ...
ejenkins said:
Unfortunately I have no System.Data.SQLite.dll file in C:\Program Files (x86)\Red Gate\SQL Search 3 so this doesn't work for me.
It's C:\ProgramData\Red Gate\SQL Search\Source not C:\Program Files (x86)\Red Gate\SQL Search 3 / comments
ejenkins said:
Unfortunately I have no System.Data.SQLite.dll file in C:\Program Files (x86)\Red Gate\SQL Search 3 so this doesn't work for me.
It's C:\ProgramData\Red Gate\SQL Search\Source...
Glad I could help - the 2 hours I spent messing around with this were not in vain! / comments
Glad I could help - the 2 hours I spent messing around with this were not in vain!
This happens because SQL Prompt uses System.Data.SQLite 1.0.85.0 which clashes with SQL search's 1.0.110.0 resulting in the indexing failing as it is not able to find the right SQLite.Interop.DLL. You can resolve this 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). That way you can have both Prompt and Search running at the same time. / comments
This happens because SQL Prompt uses System.Data.SQLite 1.0.85.0 which clashes with SQL search's 1.0.110.0 resulting in the indexing failing as it is not able to find the right SQLite.Interop.DLL.Y...
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. / comments
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...