Skip to Content.
Sympa Menu

freetds - Re: [freetds] Issue with SQLDescribeCol

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Emmanuel Stapf" <manus AT eiffel.com>
  • To: "'Frediano Ziglio'" <freddy77 AT gmail.com>, "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Issue with SQLDescribeCol
  • Date: Mon, 17 Nov 2014 09:07:43 +0100

Great. Thanks,
Manu

> -----Original Message-----
> From: Frediano Ziglio [mailto:freddy77 AT gmail.com]
> Sent: Sunday, November 16, 2014 10:33
> To: manus AT eiffel.com; FreeTDS Development Group
> Subject: Re: [freetds] Issue with SQLDescribeCol
>
> 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/5508af66b79f1c6dee70d86f9
> > c673e8b9b1b24ed
> >
> > 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/a3639342271313e32dca198e1fe065d534f
> 67b61
> Fix:
> https://gitorious.org/freetds/freetds/commit/167db70e5183ab7fd25ad1916d669ca49b6
> 2199b
>
> Backported to branch 0.91 too.
>
> Regards,
> Frediano





Archive powered by MHonArc 2.6.24.

Top of Page