Steve,
In my case I was getting OGR to get data from a database view, but it
could have been a table. I think OGR needs (would like?) to know which
column it can use for unque id. I would expect your view (or table)
would have a unique key column otherwise relation operations (like
joins) can be a problem (the db admin should be able to tell you).
Perhaps the ODBC system on Linux doesn't give OGR enough info about the
columns to automatically identify the Primary Key column. If you are
testing with ogrinfo you could user the "-fid" option after you've
identified the Primary Key column?
Best Regards,
Brent Fraser
On 5/31/2012 10:11 AM, [email protected] wrote:
Thanks Brent for your answer.
But ....view's primary key?
I'm missing something here...What do you mean by that? Do you mean a
column with a unique id in the view?
There is no such column in my view. Is ogr now needs a unique id in a
view? Because it was working before I migrate to linux with a recent
vertsion of gdal.
Also, My problem is before using CONNECTIONTYPE OGR
CONNECTION "<OGRVRTDataSource>
A simple ogrinfo like this
ODBC:username/password@WebMapDSN,v_MyPoints
Gives me the error OGR_ODBC: Table ?s???s!.????????? has no identified
FID column.
Thanks in advance
Steve
*Brent Fraser <[email protected]>*
2012-05-31 10:49
A
[email protected]
cc
[email protected]
Objet
[Polluriel potentiel] Re: [gdal-dev] ogr ODBC problem
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]_
<mailto:[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]>_*
<mailto:[email protected]>*@lists.osgeo.org*
Envoyé par : [email protected]_
<mailto:[email protected]>
2012-05-30 17:06
A
[email protected]_ <mailto:[email protected]>
cc
Objet
Re: [gdal-dev] ogr ODBC problem
On 12-05-30 5:09 PM, [email protected]_
<mailto:[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]_ <mailto:[email protected]>_
__http://lists.osgeo.org/mailman/listinfo/gdal-dev_
_______________________________________________
gdal-dev mailing list
[email protected]_ <mailto:[email protected]>
_http://lists.osgeo.org/mailman/listinfo/gdal-dev_
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
