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 OGRVRTDataSource and create geometry from point. Any clue on what I can do? thanks steve Jeff McKenna <jmcke...@gatewaygeomatics.com>@lists.osgeo.org Envoyé par : gdal-dev-boun...@lists.osgeo.org 2012-05-30 17:06 A gdal-dev@lists.osgeo.org cc Objet Re: [gdal-dev] ogr ODBC problem On 12-05-30 5:09 PM, steve.tout...@inspq.qc.ca 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 gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev