Cache SQLite exception

Topics: Bugs, Windows Forms
May 11, 2013 at 12:58 PM
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"
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
May 11, 2013 at 1:21 PM
for your referenced sqlite dll, set CopyToLocal to false
May 11, 2013 at 1:43 PM
Hi again. It is not copied.
May 11, 2013 at 1:53 PM
there is no issue, windows form demo is using sqlite to store addresses, works perfectly
May 11, 2013 at 2: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 2: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.
May 11, 2013 at 2:14 PM
thats the idea ;}