Re: [sqlite] Issue with LoadExtension with Spatialite

2017-04-12 Thread Green Fields
I have had this problem. Essentially, precompiled binaries (SQLite3.dll, and System.Data.Sqlite) for Windows do not appear to allow extension loading using the SQL function. I have raised this before, http://sqlite.1065341.n5.nabble.com/Extension-Loading-td93885.html but it may need custom

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

2017-02-20 Thread Green Fields
I have attempted to compile 3.17.0 in MSVS using the 32 bit native command line No editing of sources was done I have tried the amalgamation download with cl sqlite3.c -link -dll -out:sqlite3.dll and sqlite-autoconf-317.tar.gz with nmake /f makefile.msc In both cases the dll was produced

Re: [sqlite] Extension Loading

2017-02-13 Thread Green Fields
>You could create a user-defined function to call LoadExtension(), but >why do you need to do this from SQL? A good question, but I am attempting to use a different .Net wrapper for this project which has not imported sqlite3_enable_load_extension(). The simplest thing would be to import the

[sqlite] Extension Loading

2017-02-12 Thread Green Fields
Hi I'm using System.Data.SQLite Nuget package and attempting to load an extension. All depenent libraries are in the bin\debug output directory. Extension is 32 bit and the project is set to compile for 32 bit Using conn.EnableExtensions(true);(I think this is enabled by default)

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

2015-02-01 Thread Green Fields
and not the desktop? Thanks Duncan From: Green Fields [mailto:defn...@gmail.com] Sent: Sunday, 18 January 2015 3:46 PM To: 'sqlite-users@sqlite.org' Subject: System.Data.SQLite for Pocket PC & RTREE Hi I hope this message doesn't double up but the last one did not appear to make it.

[sqlite] System.Data.SQLite for Pocket PC & RTREE

2015-01-17 Thread Green Fields
Hi I hope this message doesn't double up but the last one did not appear to make it. I'm new to the list and newish to SQLite and would appreciate some tips. I'm attempting to create an application that requires a spatial rtree query, and this works extremely well using the x86 version of

[sqlite] System.Data.SQLite for Pocket PC & RTREE

2015-01-15 Thread Green Fields
Hi I'm new to the list and newish to SQLite and would appreciate some tips. I'm attempting to create an application that requires a spatial rtree query, and this works extremely well using the x86 version of the System.Data.SQLite library