[gdal-dev] RE [Polluriel potentiel] Re: ogr ODBC problem

[Brent Fraser]

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, Steve.Toutant at inspq.qc.ca 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 at WebMapDSN,v_MyPoints
>
> Gives me the error OGR_ODBC: Table ?s???s!.????????? has no identified 
> FID column.
>
> Thanks in advance
> Steve
>
>
>
>
>
> *Brent Fraser <bfraser at geoanalytic.com>*
>
> 2012-05-31 10:49
>
> 	
> A
> 	Steve.Toutant at inspq.qc.ca
> cc
> 	gdal-dev at lists.osgeo.org
> 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 at 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, _Steve.Toutant at inspq.qc.ca_ 
> <mailto:Steve.Toutant at inspq.qc.ca>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 **_<jmckenna at gatewaygeomatics.com>_* 
> <mailto:jmckenna at gatewaygeomatics.com>*@lists.osgeo.org*
> Envoyé par : _gdal-dev-bounces at lists.osgeo.org_ 
> <mailto:gdal-dev-bounces at lists.osgeo.org>
>
> 2012-05-30 17:06
>
> 	
> A
> 	_gdal-dev at lists.osgeo.org_ <mailto:gdal-dev at lists.osgeo.org>
> cc
> 	
> Objet
> 	Re: [gdal-dev] ogr ODBC problem
>
>
>
>
> 	
>
>
>
>
>
>
>
>
> On 12-05-30 5:09 PM, _Steve.Toutant at inspq.qc.ca_ 
> <mailto:Steve.Toutant at inspq.qc.ca>wrote:
> >
> > Hi!
> > I use this command to get the tables from an ODBC connection
> > ogrinfo ODBC:User/Pwd at 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_
> __gdal-dev at lists.osgeo.org_ <mailto:gdal-dev at lists.osgeo.org>_
> __http://lists.osgeo.org/mailman/listinfo/gdal-dev_
>
>
>
> _______________________________________________
> gdal-dev mailing list
> _gdal-dev at lists.osgeo.org_ <mailto:gdal-dev at lists.osgeo.org>
> _http://lists.osgeo.org/mailman/listinfo/gdal-dev_
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120531/4c4e7e6e/attachment.html>