MapGuide Enterprise Wishes

Reply
*Paul
Message 1 of 2 (201 Views)

OLEDB/ODBC driver for SDF3

201 Views, 1 Replies
11-22-2006 02:06 PM
How do I query data if SDF3 is my database. Can we expect OLEDB/ODBC driver
for SDF3?

I heard SDF3 is based on Sqlite technology. I've seen ODBC drivers for
Sqlite but I don't think they work with SDF3.
*Jason Birch
Message 2 of 2 (201 Views)

Re: OLEDB/ODBC driver for SDF3

11-22-2006 08:10 PM in reply to: *Paul
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

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community