Steve,
Here's a snippet from a MapServer map file I used to access a
non-spatial MS SQL server via OGR+VRT+ODBC:
TYPE POINT
CONNECTIONTYPE OGR
CONNECTION "<OGRVRTDataSource>
<OGRVRTLayer name='v_MyPoints'>
<SrcDataSource>ODBC:username/password@WebMapDSN,v_MyPoints</SrcDataSource>
<SrcSQL>
SELECT * FROM v_MyPoints
WHERE PropertyID=%PropertyID%
</SrcSQL>
*<FID>PointID</FID>*
<GeometryType>wkbPoint</GeometryType>
<GeometryField encoding='PointFromColumns' y='SurfaceLatitude'
x='SurfaceLongitude'/>
<LayerSRS>NAD83</LayerSRS>
</OGRVRTLayer>
</OGRVRTDataSource>"
PROCESSING "CLOSE_CONNECTION=DEFER"
DATA "v_MyPoints"
In my case I was able to use the view's primary key as the FID. Hope
this helps...
Best Regards,
Brent Fraser
On 5/31/2012 7:48 AM, [email protected] wrote:
Thanks Jeff
I got now OGR_ODBC: Table ?s???s!.????????? has no identified FID column.
I found that several users had this problem but found no solution. I
don't have write access to this MSSQL server.
I'm connecting via ODBC to a non spatial table, but it contains
latitude and longitude information. I will use it to define a
OGRVRTDataSourceand create geometry from point.
Any clue on what I can do?
thanks
steve
*Jeff McKenna <[email protected]>@lists.osgeo.org*
Envoyé par : [email protected]
2012-05-30 17:06
A
[email protected]
cc
Objet
Re: [gdal-dev] ogr ODBC problem
On 12-05-30 5:09 PM, [email protected] wrote:
>
> Hi!
> I use this command to get the tables from an ODBC connection
> ogrinfo ODBC:User/Pwd@DNS
>
> The connection is succesful but I get this error several times
> ERROR 1: No column definitions found for table '?s???s!.???????????',
> layer not usable.
>
> I used OGR ODBC for several months from a Windows server to a MSSQL
server
> Now I'm migrating to linux and accessing the same MSSQL SERVER and I get
> this error.
>
> Note that if I connect with isql, I can connect and query the database
> without problem.
> So the problem really seems to be with OGR
>
> What can cause this No column definitions found for table error
> And why the table name looks like this '?s???s!.???????????',
Hi Steve,
I was just debugging an ogrinfo command for MS4W/Oracle, and was
reminded of the trick to show more debug info at the commandline:
set CPL_DEBUG=on
I'm going to keep that one in my back pocket from now on.
-jeff
--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
