MICHAEL INGERSOLL

mingersoll · March 15, 2019 8:41PM

SQL Search is not returning any results when using it in SSMS 2017. CHecking the log files, I find the following error when indexing:

ERROR ServerObjectIndexer - Exception while indexing server:

System.EntryPointNotFoundException: Unable to find an entry point named 'sqlite3_open_interop' in DLL 'SQLite.Interop.dll'.

This error occurs for any database I try. What are possible causes of this error?
Thanks in advance.

Eddie D · March 18, 2019 9:30AM

Hi, thank you for your forum post.

What version of SQL Search are you using?

A support ticket has been created for you. I will send a private message with the details of the support ticket.

Many Thanks
Eddie

mingersoll · March 18, 2019 1:25PM

Version 3.2.4.2262

mingersoll · March 18, 2019 1:52PM

I just found a work-around, but it is not very practical.

I uninstalled the entire SQL Toolbelt suite and reinstalled only SQL Search and it worked. The application properly indexed the databases and the error listed previously did not occur.

Eddie D · March 18, 2019 2:22PM

Thank you for your replies.

I agree not a very practical solution. Have you reinstalled any of the other applications of the SQL Toolbelt? If the answer is not yet, can you please try reinstalling SQL Compare and SQL Data Compare? If you can continue using SQL Search, can you then please try SQL Prompt?

Many Thanks
Eddie

rweingartner · March 19, 2019 12:33PM

I was having the same exact issue. I had SQL Compare, SQL Data Compare, SQL Prompt, and SQL Search installed and had the issue with SQL Search.

I uninstalled SQL Compare, SQL Data Compare, and SQL Prompt. (Did not uninstall SQL Search). SQL Search worked.

In reinstalled SQL Compare and SQL Data Compare, SQL Search still worked.

I reinstalled SQL Prompt and SQL search stopped working.

I uninstalled SQL Prompt and SQL search started working again.

Hope this helps other people and in the research of the issue.

Vivan · March 20, 2019 1:22PM

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.

eg4325 · March 21, 2019 9:00PM

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.

Eddie D · March 22, 2019 8:47AM

The problem has been identified as a mis-match between a third party component that both SQL Search and SQL Prompt use.

This is now resolved by upgrading to the latest versions of both SQL Prompt and SQL Search using this link to the latest SQL Toolbelt installer.

Many Thanks
Eddie

mingersoll · March 22, 2019 9:50AM

Thanks rweingartner.

I found the exact same issue. After having success by uninstalling everything and only reinstalling SQL Search, I then reinstalled everything else except SQL Prompt. SQL Search continued to work afterward.

There seems to be some conflict between SQL Prompt and SQL Search. I'm not using Prompt at all, so I guess this solves my problem...

...but the overall issue remains.

risho · January 11, 2022 9:21AM

Hello,
having error: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

after uninstalling SQL Prompt and reinstall SQL Search error not showing, but search returns no results.

any suggestions how to make SQL Search working again?

SQL Search version: 3.5.5.2703
OS: Microsoft Windows 10 Enterprise
framework: 4.8.04084
SSMS file version: 2019.0150.18390.00 ((SSMS_Rel).211001-1445)
SSMS product version: 15.0.18390.0

Thanks

MICHAEL INGERSOLL

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk