Exception while processing Server Explorer drag: System.EntryPointNotFoundException: Unable to find an entry point named 'sqlite3_open_interop' in DLL 'System.Data.SQLite.dll'

Hello,

I cannot drag and drop tables on to the lightspeed design surface. I receive the following exception:

Exception while processing Server Explorer drag: System.EntryPointNotFoundException: Unable to find an entry point named 'sqlite3_open_interop' in DLL 'System.Data.SQLite.dll'.
   at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_interop(Byte[] utf8Filename, SQLiteOpenFlagsEnum flags, IntPtr& db)
   at System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
   at System.Data.SQLite.SQLiteConnection.Open()
   at Mindscape.LightSpeed.Generator.Extraction.Sqlite3.OpenConnectionCore()
   at Mindscape.LightSpeed.Generator.Extraction.Provider`1.OpenConnection()
   at Mindscape.LightSpeed.Generator.Extraction.Provider`1.ExtractModel(Boolean pluralise, IList`1 tablesToFullyPopulate)
   at Mindscape.LightSpeed.Generator.Integration.EntityExtractor.PopulateTypeModel(IList`1 tableNames, Boolean pluralisedInDatabase)
   at Mindscape.LightSpeed.Generator.Integration.EntityBuilder.AddTablesToModel(Model model, IDesignTimeNamingStrategy namingStrategy, ILightSpeedDataSource connection, IEnumerable`1 tableNames, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.DiagramDragDropHandler.<>c__DisplayClass6.<OnDragDrop>b__4(DragObject dragObject, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.ServerExplorer.IfIsServerExplorerDrag(DragEventArgs e, DragAction action)

My datasource is SQLite. I installed the version of sqlite that is the only version that integrates with VS2012:

sqlite-netFx451-binary-Win32-2013-1.0.94.0

Mindscape Lightspeed version installed:

5.0.2597.0

v2.0.50727

To begin, I followed the walkthough in this screencast: http://www.mindscapehq.com/products/lightspeed/screencasts/getting-started

My app.config looks like this:

<configuration>
  <system.data>
    <DbProviderFactories>
      <remove invariant="System.Data.SQLite" />
      <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite"
           type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.98.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
    </DbProviderFactories>
  </system.data>
</configuration>

I did notice that I have two versions of System.Data.Sqlite in my GAC:

v4.01.0.96.0_db937bc2d44ff139

v4.01.0.98.0_db937bc2d44ff139

This person posted a similar issue (albeit 7 years ago): http://www.mindscapehq.com/forums/thread/1359 ...but their solution is now outdated as we are on versions well past the stated nightly build fix.

Any assistance would be greatly appreciated.

I am guessing it will be the same issue as LightSpeed is targetting version 1.0.86. Did you try adding a binding redirect? As per:

in the meantime the problem can be addressed by setting up a binding redirect for 1.0.48.0, redirecting it to 1.0.58.0. You can do this either at the devenv.exe application level or at the machine level. (I am sure you are familiar with setting up redirects, but just in case: go into Administrative Tools > Microsoft .NET Framework 2.0 Configuration; go into Configured Assemblies and choose Add Configured Assembly; enter System.Data.SQLite and the appropriate public key token; and on the Binding Policy tab enter Requested Version 1.0.48.0 and New Version 1.0.58.0. Or, if you want the redirect to apply to Visual Studio only, go into Applications, add devenv.exe, go to the Configured Assemblies node underneath that, and proceed as above.) Let us know if this doesn't work around the problem for you, and as I say I will continue to investigate for a proper fix.

Jeremy

Hi

Thank you for replying, Jeremy. I went ahead and followed your advice. Here is what I found out:

Mscorcfg.msc - the name of a utility that allows you to perform redirects. It no longer ships with Windows or with Microsoft .Net. Confusingly, one must install Microsoft .Net SDK 2.0 to gain access to it. I have a x64 windows operating system, therefore I installed the 64x version of Mscorcfg.msc. See the the next two links for assistance:

https://msdn.microsoft.com/en-US/library/2bc0cxhc%28v=vs.100%29.aspx

http://stackoverflow.com/questions/7894328/where-is-the-net-configuration-tool-mscorcfg-msc-in-windows-7

...after it is installed one can pick up where the instructions for redirecting it to the new version leave off.

The next confusing part about the redirection process is what to enter for Assembly Name and Public key token. The Assembly name is simple: System.Data.SQLite. The public key token is slightly more difficult to determine. Here are the steps that I followed:

1) navigate to: C:\Windows\Microsoft.NET\assembly\GAC_64\System.Data.SQLite

2) in my folder there is: v4.01.0.97.0_db937bc2d44ff139

3) that last bit is the public key token: db937bc2d44ff139

to confirm, open a visual studio command prompt: Choose Start, expand All Programs, and then expand Microsoft Visual Studio. Depending on the version of Visual Studio you have installed, choose Visual Studio Tools, Visual Studio Command Prompt, or the command prompt you want to use.

The perform the following command:

C:\Windows\Microsoft.NET\assembly\GAC32\System.Data.SQLite\v4.01.0.98.0__db937 bc2d44ff139>sn -T System.Data.SQLite.dll

Microsoft (R) .NET Framework Strong Name Utility Version 4.0.30319.17929 Copyright (c) Microsoft Corporation. All rights reserved.

Public key token is db937bc2d44ff139

...and they appear to be identical, therefore one has confirmed the correct public key token. But, doesn't this seem odd to anyone else? If you look closely, all versions of the System.Data.SQLite have the same public key token, be it an old or new version, or even x32 or x64. Intuitively one would expect a public key token to be unique - hence the word "key". For example, here is the 64 bit version of the same .dll:

C:\Windows\Microsoft.NET\assembly\GAC64\System.Data.SQLite\v4.01.0.97.0__db937 bc2d44ff139>sn -T System.Data.SQLite.dll

Microsoft (R) .NET Framework Strong Name Utility Version 4.0.30319.17929 Copyright (c) Microsoft Corporation. All rights reserved.

Public key token is db937bc2d44ff139

On my machine, I have 2 older versions. Also, because Jeremy mentioned version 1.0.86.0 (was that a typo Jeremy?). Therefore my binding policy looks like this:

1.0.86.0 -> 1.0.98.0

1.0.96.0 -> 1.0.98.0

1.0.97.0 -> 1.0.98.0

I then clicked APPLY and clicked out of the dialog. I restarted Visual Studio. I opened my project. I drag and dropped a table from my SQLite database. Result: same as before...I received the identical exception. Therefore I either performed the redirection incorrectly, or, it wasn't the cause of the exception.

Any help?

The public key token will be the same as all of the versions are signed by the same key - the key token is just a short form of the public key that signed the assembly, its not a hash of the assembly itself.

Try applying the binding redirects to the devenv.exe.config file under C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE - Im guessing they have not been picked up from the changes made by that tool.

Jeremy

I went ahead and re-imaged my computer. Not because of this issue, just a lucky coincidence.

Starting with Windows 7 Enterprise and all the appropriate installs for SQLite and Visual Studio. I get exactly the same error. And what is there to redirect? There is only one reference in my GAC.

Exception while processing Server Explorer drag: System.EntryPointNotFoundException: Unable to find an entry point named 'sqlite3openinterop' in DLL 'System.Data.SQLite.dll'. at System.Data.SQLite.UnsafeNativeMethods.sqlite3openinterop(Byte[] utf8Filename, SQLiteOpenFlagsEnum flags, IntPtr& db) at System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) at System.Data.SQLite.SQLiteConnection.Open() at Mindscape.LightSpeed.Generator.Extraction.Sqlite3.OpenConnectionCore() at Mindscape.LightSpeed.Generator.Extraction.Provider1.OpenConnection() at Mindscape.LightSpeed.Generator.Extraction.Provider1.ExtractModel(Boolean pluralise, IList1 tablesToFullyPopulate) at Mindscape.LightSpeed.Generator.Integration.EntityExtractor.PopulateTypeModel(IList1 tableNames, Boolean pluralisedInDatabase) at Mindscape.LightSpeed.Generator.Integration.EntityBuilder.AddTablesToModel(Model model, IDesignTimeNamingStrategy namingStrategy, ILightSpeedDataSource connection, IEnumerable`1 tableNames, IGenerationLog log) at Mindscape.LightSpeed.Generator.Integration.DiagramDragDropHandler.<>cDisplayClass6.b4(DragObject dragObject, IGenerationLog log) at Mindscape.LightSpeed.Generator.Integration.ServerExplorer.IfIsServerExplorerDrag(DragEventArgs e, DragAction action)

I was really hoping to use Lightspeed. This basic setup error is making this a deal breaker. If someone from Mindscape would like to assist, you might just have yourself a customer. But from my point of view after reimaging it should "have just worked". Endlessly trying out fixes is not a good sign for future use of this application.

Try applying the binding redirects to the devenv.exe.config file under C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE - Im guessing they have not been picked up from the changes made by that tool.

The difference in versions will be coming from LightSpeed targeting an earlier version of SQLite, because SQLite is strongly named a newer version isnt automatically able to be used so the binding redirect does need to be applied to indicate this is possible.

Jeremy