Paul wrote:
> I heard SDF3 is based on Sqlite technology. I've seen ODBC drivers for
> Sqlite but I don't think they work with SDF3.
Although I also see the utility in an OLEDB/ODBC driver for SDF3 (or
more usefully, making SDF3 files accessible as SQLite) in the meantime
you can run queries against SDF3 files using either MapGuide or FDO
directly.
The MapGuide FeatureService has some good examples:
https://mapguide.osgeo.org/nonav/docs/webapi/de/ddf/group___feature___service___module.html
If you want something with a bit less overhead, using FDO directly is
possible, though it's still somewhat uncharted territory:
https://fdo.osgeo.org/docs/FET_TheEssentialFDO.pdf
https://fdo.osgeo.org/docs/FDG_FDODevGuide.pdf
https://fdo.osgeo.org/nonav/docs/FDO_API_managed/index.html
And there are examples of the API in the unit tests, which you can
download from SVN:
https://fdocore.osgeo.org/source/browse/fdocore/branches/3.2.x/Fdo/Managed/UnitTest/
Jason