[gdal-dev] ogr ODBC problem

[Steve.Toutant at inspq.qc.ca]

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 <jmckenna at gatewaygeomatics.com>@lists.osgeo.org 
Envoyé par : gdal-dev-bounces at lists.osgeo.org
2012-05-30 17:06

A
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 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
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/ce33648b/attachment-0001.html>