[gdal-dev] Issue with ogrinfo: unixODBC and MS SQL

[Frank Warmerdam]

Gregor at HostGIS wrote:
> Hey guys. I posted a few days ago about a problem with using ogrinfo to 
> read ODBC from a MS SQL server.
> 
> $ ogrinfo test.ovf
> ERROR 1: No column definitions found for table 
> '�o��y.����y', layer not usable.
> (... and so on, more binary table names ...)
> 
> I can connect to the ODBC/MSSQL using the isql program, but not ogrinfo. 
> I can render ODBC layers if their server is PostgreSQL or MySQL. Just 
> not ogrinfo and MS SQL.
> 
> Any advice on how I can proceed with troubleshooting this?

Gregor,

I presume this is due to mishandling of a wide character column or
something like that. You could add some debug statements in the
gdal/port/cpl_odbc.cpp code in an attempt to determine what column
type is coming back for the problem columns and see if that suggests
anything.

Debuging MS SQL related bugs isn't really all that convenient for me.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent