Cache SQLite exception

Topics: Bugs, Windows Forms
May 11, 2013 at 11:58 AM
Hi Radioman!
I'm having an issue with CacheOnly mode. I have a cache folder created by demo - Prefetch.
But when I use my dll that uses Gmap in my application cache is not used and exceptions are thrown on tiles.
Visual studio debug is looking like this:

"POSForms.vshost.exe" (Managed (v4.0.30319)): Loaded "C:\Users\fox\AppData\Local\GMap.NET\DllCache\SQLite_v84_NET4_x86\System.Data.SQLite.DLL"
SQLiteVersion: 3.7.14 | 2012-09-03 15:42:36 c0d89d4a9752922f9e367362366efde4f1b06f2a | INTEROP_CODEC INTEROP_EXTENSION_FUNCTIONS NET_40 PRELOAD_NATIVE_LIBRARY THROW_ON_DISPOSED TRACE TRACE_PRELOAD TRACE_WARNING
SQLite error (21): misuse at line 111924 of [c0d89d4a97]
WARNING: Type mapping failed, returning default type Object for name "byte".
SQLite error (21): misuse at line 111924 of [c0d89d4a97]

It seems to me that 2 SQLite dlls conflicting cause I have SQLite Db that I should work with.
I've already placed my SQLite usage into separate dll-module but there's still no use.
Could suggest some solution or make Gmap use existing SQLite.dll links in application?
Thanks a lot upfront
Coordinator
May 11, 2013 at 12:21 PM
for your referenced sqlite dll, set CopyToLocal to false
May 11, 2013 at 12:43 PM
Hi again. It is not copied.
Coordinator
May 11, 2013 at 12:53 PM
there is no issue, windows form demo is using sqlite to store addresses, works perfectly
May 11, 2013 at 1:02 PM
Hi, I've resolved an issue. Solution was to copy same SQLite.dll version into default DllCache\some_sqlite_version_folder\ (for me it is C:\Users***\AppData\Local\GMap.NET\DllCache\SQLite_v84_NET4_x86).
But still it has to be resolved some other way. At least it is required for you to use SQLite.dll from cache folder that we specify in cachelocation or primary/secondary cache.
I hope you'll find the solution and resolve problem. I'll copy comment to issue I've added to issue tracker.
May 11, 2013 at 1:03 PM
radioman wrote:
there is no issue, windows form demo is using sqlite to store addresses, works perfectly
That's because same versions are used I guess.
Coordinator
May 11, 2013 at 1:14 PM
thats the idea ;}