Skip to Content.
Sympa Menu

freetds - Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns
  • Date: Thu, 2 Aug 2012 11:36:39 -0400

On Thu, 2 Aug 2012 10:58:45 +0200
Lionel Elie Mamane <lionel AT mamane.lu> 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





Archive powered by MHonArc 2.6.24.

Top of Page