Use of RTree

FObermaier · Post by **FObermaier** » Mon 28 Mar 2011 06:51

Hello,

I'm trying to access a sqlite/spatialite (www.gaia-gis.it/spatialite) database with dotConnect for SQLite. SpatiaLite relies on SQLites RTree module but I get an error stating RTRee module not found?

Is this SQLite feature omitted on purpose or is there some way to enable it?

Kind regards
FObermiaer

Shalex · Post by **Shalex** » Tue 29 Mar 2011 13:12

We will investigate the dotConnect for SQLite compatibility with SpatiaLite and notify you about the results.

FObermaier · Post by **FObermaier** » Tue 29 Mar 2011 13:37

Shalex wrote:We will investigate the dotConnect for SQLite compatibility with SpatiaLite and notify you about the results.

Thanks. You may want to look at
http://sharpmap.codeplex.com/

If you download the source via svn from trunk you'll find a provider for spatialite in the SharpMap.Extensions project. It currently uses System.Data.SQLite. In the WinFormSamples project, you'll find a sample database.

Cheers FObermaier

Shalex · Post by **Shalex** » Tue 05 Apr 2011 10:56

Please load the SpatiaLite dll as an extension in the following way: http://sqlite.phxsoftware.com/forums/p/1608/6913.aspx.

Here are also useful links:
http://www.gaia-gis.it/spatialite/install-windows.html
http://groups.google.com/group/spatiali ... d2da9b2ae1
http://geobabble.wordpress.com/2009/04/ ... arpmap-09/

FObermaier · Post by **FObermaier** » Tue 05 Apr 2011 13:18

Are you saying it should work?
For the devart sqlite connection you need to set enableloadextension for the load_extension function to work at all.
The code you mentioned is not new to me, in fact I'm using the spatialite provider for sharpmap. It just happens to throw the exception that the RTree module is not found.

FObermaier

Shalex · Post by **Shalex** » Mon 11 Apr 2011 13:05

We are investigating the issue.

FObermaier · Post by **FObermaier** » Mon 23 May 2011 08:56

Shalex wrote:We are investigating the issue.

Any progress on the issue?

Shalex · Post by **Shalex** » Tue 31 May 2011 15:12

Sorry for the delay.
Could you please specify a sample code we should run to reproduce the error with SharpMap.Extensions.dll v 0.9.4168.30241 (assuming that we have rebuilt it with dotConnect for SQLite) against the sample.sqlite database from the WinFormSamples project? As I understood, it works with System.Data.SQLite but does not with Devart.Data.SQLite. Is this correct? Please post your code here or send it to us via our contact form.