RE: [gdal-dev] OGR OVF has no identified FID column
Brent, Finally got back to this today. I upgraded my GDAL to version 1.7.1. The only thing I notice that is different is that I get: OGR: OGRGeometryFactory::createFromWkb() - got corrupt data. That gave me a hint. I added a WKT column to the MS SQL Server table and calculated it to the STAsText of the Feature column. Then I modified the ovf file to look for WKT in the WKT column. Still no FID, but the point data ogr sees is what I expect: Layer name: PointData Geometry: Unknown (any) OGR_ODBC: ExecuteSQL(SELECT * FROM PointData) Feature Count: 1 OGR_ODBC: ExecuteSQL(SELECT * FROM PointData) Layer SRS WKT: (unknown) PKey: Integer (10.0) Feature: Binary (0.0) WKT: String (0.0) OGR_ODBC: ExecuteSQL(SELECT * FROM PointData) OGRFeature(PointData):3 PKey (Integer) = 3 Feature (Binary) = BC08010C59405940 WKT (String) = POINT (100 100) POINT (100 100) Thanks again for your help. David Lowther Coordinate Solutions, Inc. -Original Message- From: Brent Fraser [mailto:bfra...@geoanalytic.com] Sent: Friday, August 20, 2010 10:16 AM To: David Lowther Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] OGR OVF has no identified FID column David, GDAL: POINT (0.0 2.0021871) SQL Server: POINT (150 150) That IS strange! There could be a problem with GDAL's or SQL Server's encoding/decoding of WKB, or it could be related to data type (geometry? geography?) or the lack of a Spatial Reference System? Best Regards, Brent Fraser David Lowther wrote: D:\Utility\ms4w\tools\gdal-ogrogrinfo test.ovf PointData --debug on ERROR 4: Update access not supported for VRT datasources. OGR_ODBC: EstablishSession(DSN:CLO, userid:un, password:pw) ODBC: SQLConnect(CLO) OGR_ODBC: Table PointData has no identified FID column. OGR: OGROpen(ODBC:un/p...@clo,PointData/00FB9BB0) succeeded as ODBC. OGR: OGROpen(test.ovf/010870B8) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 Layer name: PointData Geometry: Unknown (any) OGR_ODBC: ExecuteSQL(SELECT * FROM PointData) Feature Count: 1 OGR_ODBC: ExecuteSQL(SELECT * FROM PointData) Extent: (0.00, 2.00) - (0.00, 2.00) Layer SRS WKT: (unknown) PKey: Integer (10.0) Feature: Binary (0.0) OGR_ODBC: ExecuteSQL(SELECT * FROM PointData) OGRFeature(PointData):1 PKey (Integer) = 1 Feature (Binary) = 010C00C0624000C06240 POINT (0.0 2.0021871) VRT: 2 features read on layer 'PointData'. OGR_ODBC: 3 features read on layer 'PointData'. ODBC: SQLDisconnect() And, why do you think it is saying 0.0 2.00... for the point when the SQL query says? 1 0x010C00C0624000C06240 POINT (150 150) David Lowther Coordinate Solutions, Inc. -Original Message- From: Brent Fraser [mailto:bfra...@geoanalytic.com] Sent: Thursday, August 19, 2010 5:21 PM To: David Lowther Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] OGR OVF has no identified FID column I think it's faster since it doesn't have to enumerate all the tables,views, etc. so how do you get for attributes names when you do a ogrinfo test.ovf PointData --debug on Brent David Lowther wrote: Still doesn't see the FID but is way faster! OGRVRTDataSource OGRVRTLayer name=PointData SrcDataSourceODBC:un/p...@clo,PointData/SrcDataSource GeometryField encoding=WKB field=Feature/ FIDPKey/FID /OGRVRTLayer /OGRVRTDataSource ogrinfo test.ovf --debug on ERROR 4: Update access not supported for VRT datasources. OGR_ODBC: EstablishSession(DSN:CLO, userid:un, password:pw) ODBC: SQLConnect(CLO) OGR_ODBC: Table PointData has no identified FID column. OGR: OGROpen(ODBC:un/p...@clo,PointData/02799B88) succeeded as ODBC. OGR: OGROpen(test.ovf/010270B8) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 1: PointData ODBC: SQLDisconnect() Does the datatype of the FID column matter? I have it as an int, does it need to be guid? David Lowther Coordinate Solutions, Inc. -Original Message- From: Brent Fraser [mailto:bfra...@geoanalytic.com] Sent: Thursday, August 19, 2010 3:49 PM To: David Lowther Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] OGR OVF has no identified FID column Yeah I saw that after I sent the message. Take out the SrcSQL, it's really only useful if want to do special things, and it can kill spatial indexing on ODBC datasources. Does this work any better: OGRVRTDataSource OGRVRTLayer name=UserPoint SrcDataSourceODBC:un/p...@clo,PointData/SrcDataSource GeometryField encoding=WKB field=Feature/ FIDPKey/FID /OGRVRTLayer /OGRVRTDataSource Brent David Lowther wrote: Brent
Re: [gdal-dev] OGR OVF has no identified FID column
David, GDAL: POINT (0.0 2.0021871) SQL Server: POINT (150 150) That IS strange! There could be a problem with GDAL's or SQL Server's encoding/decoding of WKB, or it could be related to data type (geometry? geography?) or the lack of a Spatial Reference System? Best Regards, Brent Fraser David Lowther wrote: D:\Utility\ms4w\tools\gdal-ogrogrinfo test.ovf PointData --debug on ERROR 4: Update access not supported for VRT datasources. OGR_ODBC: EstablishSession(DSN:CLO, userid:un, password:pw) ODBC: SQLConnect(CLO) OGR_ODBC: Table PointData has no identified FID column. OGR: OGROpen(ODBC:un/p...@clo,PointData/00FB9BB0) succeeded as ODBC. OGR: OGROpen(test.ovf/010870B8) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 Layer name: PointData Geometry: Unknown (any) OGR_ODBC: ExecuteSQL(SELECT * FROM PointData) Feature Count: 1 OGR_ODBC: ExecuteSQL(SELECT * FROM PointData) Extent: (0.00, 2.00) - (0.00, 2.00) Layer SRS WKT: (unknown) PKey: Integer (10.0) Feature: Binary (0.0) OGR_ODBC: ExecuteSQL(SELECT * FROM PointData) OGRFeature(PointData):1 PKey (Integer) = 1 Feature (Binary) = 010C00C0624000C06240 POINT (0.0 2.0021871) VRT: 2 features read on layer 'PointData'. OGR_ODBC: 3 features read on layer 'PointData'. ODBC: SQLDisconnect() And, why do you think it is saying 0.0 2.00... for the point when the SQL query says? 1 0x010C00C0624000C06240 POINT (150 150) David Lowther Coordinate Solutions, Inc. -Original Message- From: Brent Fraser [mailto:bfra...@geoanalytic.com] Sent: Thursday, August 19, 2010 5:21 PM To: David Lowther Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] OGR OVF has no identified FID column I think it's faster since it doesn't have to enumerate all the tables,views, etc. so how do you get for attributes names when you do a ogrinfo test.ovf PointData --debug on Brent David Lowther wrote: Still doesn't see the FID but is way faster! OGRVRTDataSource OGRVRTLayer name=PointData SrcDataSourceODBC:un/p...@clo,PointData/SrcDataSource GeometryField encoding=WKB field=Feature/ FIDPKey/FID /OGRVRTLayer /OGRVRTDataSource ogrinfo test.ovf --debug on ERROR 4: Update access not supported for VRT datasources. OGR_ODBC: EstablishSession(DSN:CLO, userid:un, password:pw) ODBC: SQLConnect(CLO) OGR_ODBC: Table PointData has no identified FID column. OGR: OGROpen(ODBC:un/p...@clo,PointData/02799B88) succeeded as ODBC. OGR: OGROpen(test.ovf/010270B8) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 1: PointData ODBC: SQLDisconnect() Does the datatype of the FID column matter? I have it as an int, does it need to be guid? David Lowther Coordinate Solutions, Inc. -Original Message- From: Brent Fraser [mailto:bfra...@geoanalytic.com] Sent: Thursday, August 19, 2010 3:49 PM To: David Lowther Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] OGR OVF has no identified FID column Yeah I saw that after I sent the message. Take out the SrcSQL, it's really only useful if want to do special things, and it can kill spatial indexing on ODBC datasources. Does this work any better: OGRVRTDataSource OGRVRTLayer name=UserPoint SrcDataSourceODBC:un/p...@clo,PointData/SrcDataSource GeometryField encoding=WKB field=Feature/ FIDPKey/FID /OGRVRTLayer /OGRVRTDataSource Brent David Lowther wrote: Brent, Thanks for the reply. On initial read I thought you had found my issue - that I was trying so many things I finally messed it all up. But on closer inspection I am aliasing the PKey column to FID in the SrcSQL (select PKey as FID, Feature from PointData). When FIDFID/FID ogrinfo returns: ODBC: ExecuteSQL(select PKey as FID, Feature from PointData) called. OGR_ODBC: Table SELECT has no identified FID column. OGR: OGROpen(test.ovf/00ED7090) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 1: UserPoint OGR: ReleaseDataSource(ODBC:un/p...@clo/02719D10) dereferenced and now destroying. ODBC: SQLDisconnect() When FIDPKEY/FID ogrinfo returns: ODBC: ExecuteSQL(select PKey as FID, Feature from PointData) called. OGR_ODBC: Table SELECT has no identified FID column. ERROR 1: Unable to identify FID field 'PKey'. OGR: ReleaseDataSource(ODBC:un/p...@clo/02C39D18) dereferenced and now destroying. ODBC: SQLDisconnect() FAILURE: Unable to open datasource `test.ovf' with the following drivers. - ESRI Shapefile David Lowther Coordinate Solutions, Inc. -Original Message- From: Brent Fraser [mailto:bfra...@geoanalytic.com] Sent: Thursday, August 19, 2010 3:15 PM To: David Lowther Cc: gdal
RE: [gdal-dev] OGR OVF has no identified FID column
Brent, Thanks for the reply. On initial read I thought you had found my issue - that I was trying so many things I finally messed it all up. But on closer inspection I am aliasing the PKey column to FID in the SrcSQL (select PKey as FID, Feature from PointData). When FIDFID/FID ogrinfo returns: ODBC: ExecuteSQL(select PKey as FID, Feature from PointData) called. OGR_ODBC: Table SELECT has no identified FID column. OGR: OGROpen(test.ovf/00ED7090) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 1: UserPoint OGR: ReleaseDataSource(ODBC:un/p...@clo/02719D10) dereferenced and now destroying. ODBC: SQLDisconnect() When FIDPKEY/FID ogrinfo returns: ODBC: ExecuteSQL(select PKey as FID, Feature from PointData) called. OGR_ODBC: Table SELECT has no identified FID column. ERROR 1: Unable to identify FID field 'PKey'. OGR: ReleaseDataSource(ODBC:un/p...@clo/02C39D18) dereferenced and now destroying. ODBC: SQLDisconnect() FAILURE: Unable to open datasource `test.ovf' with the following drivers. - ESRI Shapefile David Lowther Coordinate Solutions, Inc. -Original Message- From: Brent Fraser [mailto:bfra...@geoanalytic.com] Sent: Thursday, August 19, 2010 3:15 PM To: David Lowther Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] OGR OVF has no identified FID column How about using: FIDPKey/FID but that doesn't explain why it takes a long time... Best Regards, Brent Fraser David Lowther wrote: List, I have an OVF layer defined as follows: OGRVRTDataSource OGRVRTLayer name=UserPoint SrcDataSourceODBC:un/p...@clo/SrcDataSource SrcSQLselect PKey as FID, Feature from PointData/SrcSQL GeometryField encoding=WKB field=Feature/ FIDFID/FID /OGRVRTLayer /OGRVRTDataSource The ODBC connection is to a SQL Express 2008 database. The PointData table is defined as follows: CREATE TABLE [dbo].[PointData]( [PKey] [int] IDENTITY(1,1) NOT NULL, [Feature] [geometry] NULL, CONSTRAINT [PK_PointData] PRIMARY KEY CLUSTERED ( [PKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] This query select *, Feature.STAsText() from pointdata yields 1 0x010C00C0624000C06240 POINT (150 150) ogrinfo test.ovf --debug on runs for a very long time returning many lines of this sort of stuff: ERROR 4: Update access not supported for VRT datasources. OGR_ODBC: EstablishSession(DSN:CLO, userid:un, password:pw) ODBC: SQLConnect(CLO) ODBC: CatalogNameL: (null) Schema name: (null) OGR_ODBC: Table PointData has no identified FID column. OGR_ODBC: Table UserMapData has no identified FID column. OGR_ODBC: Table CHECK_CONSTRAINTS has no identified FID column. before finally saying: OGR: OGROpen(ODBC:un/p...@clo/02C79D10) succeeded as ODBC. ODBC: ExecuteSQL(select PKey as FID, Feature from PointData) called. OGR_ODBC: Table SELECT has no identified FID column. OGR: OGROpen(test.ovf/00E17090) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 1: UserPoint OGR: ReleaseDataSource(ODBC:un/p...@clo/02C79D10) dereferenced and now destroying. ODBC: SQLDisconnect() GDAL version is 1.6.0. I have tried using no FID tag and using SrcLayer instead of SrcSQL. Anybody know what I could do to make it see the FID? I'm guessing it would be a lot faster if it didn't check every table in the database for an FID... Thanks in advance for your assistance, Dave Lowther ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] OGR OVF has no identified FID column
Yeah I saw that after I sent the message. Take out the SrcSQL, it's really only useful if want to do special things, and it can kill spatial indexing on ODBC datasources. Does this work any better: OGRVRTDataSource OGRVRTLayer name=UserPoint SrcDataSourceODBC:un/p...@clo,PointData/SrcDataSource GeometryField encoding=WKB field=Feature/ FIDPKey/FID /OGRVRTLayer /OGRVRTDataSource Brent David Lowther wrote: Brent, Thanks for the reply. On initial read I thought you had found my issue - that I was trying so many things I finally messed it all up. But on closer inspection I am aliasing the PKey column to FID in the SrcSQL (select PKey as FID, Feature from PointData). When FIDFID/FID ogrinfo returns: ODBC: ExecuteSQL(select PKey as FID, Feature from PointData) called. OGR_ODBC: Table SELECT has no identified FID column. OGR: OGROpen(test.ovf/00ED7090) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 1: UserPoint OGR: ReleaseDataSource(ODBC:un/p...@clo/02719D10) dereferenced and now destroying. ODBC: SQLDisconnect() When FIDPKEY/FID ogrinfo returns: ODBC: ExecuteSQL(select PKey as FID, Feature from PointData) called. OGR_ODBC: Table SELECT has no identified FID column. ERROR 1: Unable to identify FID field 'PKey'. OGR: ReleaseDataSource(ODBC:un/p...@clo/02C39D18) dereferenced and now destroying. ODBC: SQLDisconnect() FAILURE: Unable to open datasource `test.ovf' with the following drivers. - ESRI Shapefile David Lowther Coordinate Solutions, Inc. -Original Message- From: Brent Fraser [mailto:bfra...@geoanalytic.com] Sent: Thursday, August 19, 2010 3:15 PM To: David Lowther Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] OGR OVF has no identified FID column How about using: FIDPKey/FID but that doesn't explain why it takes a long time... Best Regards, Brent Fraser David Lowther wrote: List, I have an OVF layer defined as follows: OGRVRTDataSource OGRVRTLayer name=UserPoint SrcDataSourceODBC:un/p...@clo/SrcDataSource SrcSQLselect PKey as FID, Feature from PointData/SrcSQL GeometryField encoding=WKB field=Feature/ FIDFID/FID /OGRVRTLayer /OGRVRTDataSource The ODBC connection is to a SQL Express 2008 database. The PointData table is defined as follows: CREATE TABLE [dbo].[PointData]( [PKey] [int] IDENTITY(1,1) NOT NULL, [Feature] [geometry] NULL, CONSTRAINT [PK_PointData] PRIMARY KEY CLUSTERED ( [PKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] This query select *, Feature.STAsText() from pointdata yields 1 0x010C00C0624000C06240 POINT (150 150) ogrinfo test.ovf --debug on runs for a very long time returning many lines of this sort of stuff: ERROR 4: Update access not supported for VRT datasources. OGR_ODBC: EstablishSession(DSN:CLO, userid:un, password:pw) ODBC: SQLConnect(CLO) ODBC: CatalogNameL: (null) Schema name: (null) OGR_ODBC: Table PointData has no identified FID column. OGR_ODBC: Table UserMapData has no identified FID column. OGR_ODBC: Table CHECK_CONSTRAINTS has no identified FID column. before finally saying: OGR: OGROpen(ODBC:un/p...@clo/02C79D10) succeeded as ODBC. ODBC: ExecuteSQL(select PKey as FID, Feature from PointData) called. OGR_ODBC: Table SELECT has no identified FID column. OGR: OGROpen(test.ovf/00E17090) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 1: UserPoint OGR: ReleaseDataSource(ODBC:un/p...@clo/02C79D10) dereferenced and now destroying. ODBC: SQLDisconnect() GDAL version is 1.6.0. I have tried using no FID tag and using SrcLayer instead of SrcSQL. Anybody know what I could do to make it see the FID? I'm guessing it would be a lot faster if it didn't check every table in the database for an FID... Thanks in advance for your assistance, Dave Lowther ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
RE: [gdal-dev] OGR OVF has no identified FID column
Still doesn't see the FID but is way faster! OGRVRTDataSource OGRVRTLayer name=PointData SrcDataSourceODBC:un/p...@clo,PointData/SrcDataSource GeometryField encoding=WKB field=Feature/ FIDPKey/FID /OGRVRTLayer /OGRVRTDataSource ogrinfo test.ovf --debug on ERROR 4: Update access not supported for VRT datasources. OGR_ODBC: EstablishSession(DSN:CLO, userid:un, password:pw) ODBC: SQLConnect(CLO) OGR_ODBC: Table PointData has no identified FID column. OGR: OGROpen(ODBC:un/p...@clo,PointData/02799B88) succeeded as ODBC. OGR: OGROpen(test.ovf/010270B8) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 1: PointData ODBC: SQLDisconnect() Does the datatype of the FID column matter? I have it as an int, does it need to be guid? David Lowther Coordinate Solutions, Inc. -Original Message- From: Brent Fraser [mailto:bfra...@geoanalytic.com] Sent: Thursday, August 19, 2010 3:49 PM To: David Lowther Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] OGR OVF has no identified FID column Yeah I saw that after I sent the message. Take out the SrcSQL, it's really only useful if want to do special things, and it can kill spatial indexing on ODBC datasources. Does this work any better: OGRVRTDataSource OGRVRTLayer name=UserPoint SrcDataSourceODBC:un/p...@clo,PointData/SrcDataSource GeometryField encoding=WKB field=Feature/ FIDPKey/FID /OGRVRTLayer /OGRVRTDataSource Brent David Lowther wrote: Brent, Thanks for the reply. On initial read I thought you had found my issue - that I was trying so many things I finally messed it all up. But on closer inspection I am aliasing the PKey column to FID in the SrcSQL (select PKey as FID, Feature from PointData). When FIDFID/FID ogrinfo returns: ODBC: ExecuteSQL(select PKey as FID, Feature from PointData) called. OGR_ODBC: Table SELECT has no identified FID column. OGR: OGROpen(test.ovf/00ED7090) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 1: UserPoint OGR: ReleaseDataSource(ODBC:un/p...@clo/02719D10) dereferenced and now destroying. ODBC: SQLDisconnect() When FIDPKEY/FID ogrinfo returns: ODBC: ExecuteSQL(select PKey as FID, Feature from PointData) called. OGR_ODBC: Table SELECT has no identified FID column. ERROR 1: Unable to identify FID field 'PKey'. OGR: ReleaseDataSource(ODBC:un/p...@clo/02C39D18) dereferenced and now destroying. ODBC: SQLDisconnect() FAILURE: Unable to open datasource `test.ovf' with the following drivers. - ESRI Shapefile David Lowther Coordinate Solutions, Inc. -Original Message- From: Brent Fraser [mailto:bfra...@geoanalytic.com] Sent: Thursday, August 19, 2010 3:15 PM To: David Lowther Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] OGR OVF has no identified FID column How about using: FIDPKey/FID but that doesn't explain why it takes a long time... Best Regards, Brent Fraser David Lowther wrote: List, I have an OVF layer defined as follows: OGRVRTDataSource OGRVRTLayer name=UserPoint SrcDataSourceODBC:un/p...@clo/SrcDataSource SrcSQLselect PKey as FID, Feature from PointData/SrcSQL GeometryField encoding=WKB field=Feature/ FIDFID/FID /OGRVRTLayer /OGRVRTDataSource The ODBC connection is to a SQL Express 2008 database. The PointData table is defined as follows: CREATE TABLE [dbo].[PointData]( [PKey] [int] IDENTITY(1,1) NOT NULL, [Feature] [geometry] NULL, CONSTRAINT [PK_PointData] PRIMARY KEY CLUSTERED ( [PKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] This query select *, Feature.STAsText() from pointdata yields 1 0x010C00C0624000C06240 POINT (150 150) ogrinfo test.ovf --debug on runs for a very long time returning many lines of this sort of stuff: ERROR 4: Update access not supported for VRT datasources. OGR_ODBC: EstablishSession(DSN:CLO, userid:un, password:pw) ODBC: SQLConnect(CLO) ODBC: CatalogNameL: (null) Schema name: (null) OGR_ODBC: Table PointData has no identified FID column. OGR_ODBC: Table UserMapData has no identified FID column. OGR_ODBC: Table CHECK_CONSTRAINTS has no identified FID column. before finally saying: OGR: OGROpen(ODBC:un/p...@clo/02C79D10) succeeded as ODBC. ODBC: ExecuteSQL(select PKey as FID, Feature from PointData) called. OGR_ODBC: Table SELECT has no identified FID column. OGR: OGROpen(test.ovf/00E17090) succeeded as VRT. Had to open data source read-only. INFO: Open of `test.ovf' using driver `VRT' successful. OGR: GetLayerCount() = 1 1: UserPoint OGR: ReleaseDataSource(ODBC:un/p...@clo