[gdal-dev] ogr ODBC problem

[Jeff McKenna]

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/