Re: [BUG] 0.91 SQL Anywhere SQLColumns

On Thu, 2 Aug 2012 10:58:45 +0200
Lionel Elie Mamane <[email protected]> wrote:

> When connecting to SQL Anywhere 10.0.1.3716, SQLColumns() returns
> wrong data: the columns are not at their expected
> position, don't have the right name, don't contain the right data, ...
> http://msdn.microsoft.com/en-us/library/windows/desktop/ms711683
> (v=vs.85).aspx

IOW, the column headings returned by SQLColumns in FreeTDS don't conform
to the ODBC documentation.  

Thank you for the report.  I added a note to the BUGS file.  The right
way to fix it is to rewrite the query in terms of INFORMATION_SCHEMA.
If someone would do that, it would go a long way toward fixing the
function.  

Sybase supports INFORMATION_SCHEMA nowadays, too.  How long has that
been true?  Is there any reason to test a server and fall back to
sp_columns?  

--jkl