FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2014-11-15 9:33 GMT+00:00 Emmanuel Stapf <manus AT eiffel.com>:
> Hi,
>
> I've recently been testing the EiffelStore binding to ODBC against a MSSQL 
> database. For
> that I'm using unixODBC and freetds. However our code does not work due to 
> the fact that
> when calling SQLDescribeCol with almost no arguments to get the length of 
> the column name
> it does not return anything.
>
> The code we have looks like:
>
>   rc = SQLDescribeCol(hstmt, (SQLSMALLINT) index, NULL, 0, &indColName, 
> NULL, NULL, NULL,
> NULL);
>
> I looked at the code of SQLDescribeCol and found that in very old versions 
> it would update
> indColName and in the latest version although there is a comment at line 
> 2009 of odbc.c
> that says:
>
>         /* cbColNameMax can be 0 (to retrieve name length) */
>
> but nothing to that effect. Actually if you look at the following diff:
>
> https://gitorious.org/freetds/freetds/commit/5508af66b79f1c6dee70d86f9c673e8b9b1b24ed
>
> you see that the code that used to update pcbColName has disappeared from 
> the current
> version.
>
> Am I missing something?
>
> Thanks,
> Manu
>

Was not tested/implemented correctly

Test: 
https://gitorious.org/freetds/freetds/commit/a3639342271313e32dca198e1fe065d534f67b61
Fix: 
https://gitorious.org/freetds/freetds/commit/167db70e5183ab7fd25ad1916d669ca49b62199b

Backported to branch 0.91 too.

Regards,
  Frediano