RE: [gdal-dev] OGR MS SQL Spatial driver has been added

2010-09-20 Thread David Lowther
Tamas, I altered the table and that did indeed fix up my ogrinfo results. I'm still not getting anything from Mapserver, but I am preparing a basic mapfile that should make testing easier. David Lowther Coordinate Solutions, Inc. _ From: Tamas Szekeres [mailto:s

RE: [gdal-dev] OGR MS SQL Spatial driver has been added

2010-09-20 Thread David Lowther
datum=NAD83 ellps=GRS80 no_defs END#PROJECTION STATUS DEFAULT CLASS SIZE 10 COLOR 255 0 0 END END David Lowther

RE: [gdal-dev] OGR MS SQL Spatial driver has been added

2010-09-20 Thread David Lowther
)), 0xE60E010405009A99ED6C19410A5C36419A99ED6C194100 001A8336419A99B3D01841C98336419A99B3D01841B95C36419A 99ED6C19410A5C3641010002010003) SET IDENTITY_INSERT [dbo].[MetesAndBoundsHeader] OFF David Lowther Coordinate Solutions, Inc. _ From: Tamas

RE: [gdal-dev] OGR MS SQL Spatial driver has been added

2010-09-13 Thread David Lowther
doh! thanks! David Lowther Coordinate Solutions, Inc. _ From: Abhay [mailto:abhay.me...@gmail.com] Sent: Monday, September 13, 2010 1:09 PM To: David Lowther Cc: Tamas Szekeres; gdal-dev Subject: Re: [gdal-dev] OGR MS SQL Spatial driver has been added Try using

RE: [gdal-dev] OGR MS SQL Spatial driver has been added

2010-09-13 Thread David Lowther
the shapefiles can be drawn by Mapserver and seem valid when viewed from ogrinfo. D:\Utility\release-1600-x64-gdal-mapserver\bin\gdal\apps>ogrinfo d:\data\ok\bia.shp INFO: Open of `d:\data\ok\bia.shp' using driver `ESRI Shapefile' successful. 1: bia (Polygon) Any tho

RE: [gdal-dev] OGR OVF has no identified FID column

2010-09-08 Thread David Lowther
) 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

RE: [gdal-dev] OGR OVF has no identified FID column

2010-08-19 Thread David Lowther
aying 0.0 2.00... for the point when the SQL query says? 1 0x0000010C000000C0624000C06240 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: Da

RE: [gdal-dev] OGR OVF has no identified FID column

2010-08-19 Thread David Lowther
RT' 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

RE: [gdal-dev] OGR OVF has no identified FID column

2010-08-19 Thread David Lowther
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 Mes

[gdal-dev] OGR OVF has no identified FID column

2010-08-19 Thread David Lowther
List, I have an OVF layer defined as follows: ODBC:un/p...@clo select PKey as FID, Feature from PointData FID The ODBC connection is to a SQL Express 2008 database. The PointData table is defined as follows: CREATE TABLE [dbo].[PointDat