freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
[freetds] [BUG] 0.91 SQL Anywhere SQLColumns,
Lionel Elie Mamane, 08/02/2012
-
Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns,
James K. Lowden, 08/02/2012
-
Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns,
Lionel Elie Mamane, 08/02/2012
- Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns, James K. Lowden, 08/02/2012
-
Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns,
Lionel Elie Mamane, 08/02/2012
-
Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns,
James K. Lowden, 08/02/2012
Archive powered by MHonArc 2.6.24.