[Gdal-dev] OGR OLEDB Provider

[Frank Warmerdam]

John Cole wrote:
> -1
> 
> As someone who is using an OGR VRT->ODBC->SQL Server and not knowing an
> OLEDB driver existed, I'd like to explore this thing and see if the
> performance is better than my current solution (which when compared to
> PostGIS, is sub-optimal but ok when compared to SDE).  Is there any
> documentation available for this?
> 
> Also, I'm looking forward to the release of SQL Server 2008 with its spatial
> extensions, and I would think that having an OLEDB driver would help speed
> GDAL/OGR support for this backend.

John,

The only docs on it I see just now is this at the end of the OGR page:

"""
OGR and OpenGIS Simple Features for OLE DB

With the support of SoftMap and Safe Software an OLE DB provider on top of OGR 
has been implemented, attempting to adhere to the OpenGIS Simple Features for 
COM specification to the extent possible. This implementation is not certified 
as compliant with the OpenGIS specification.

While OGR can be used via the OLE DB interface, it can also just be called 
directly as a C++ library. OGR attempts to provide an OpenGIS Simple Features 
inspired terminology and view of datasets even when used in this fashion. Note 
that there is no OpenGIS specification for a C or C++ interface.
"""

I'm sure I had a further writeup at one time, but I'm not sure where it
might be.  The code is found in gdal/ogr/sfcom_oledb.

But I think there is some confusion about the purpose of the OLE DB provider.
The OLE DB provider provides an OLE DB interface for applications wishing to
access OGR feature data.  It does *not* provide a mechanism for OGR to read
features from OLE DB enabled databases.   So I don't think it will help with
your particular situation.

I *think* FWTools for windows includes a build of the oledb provider.  If you
would like to pursue use of the provider I'd suggest contacting me privately
and I'll try to provide a few details.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org