FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

Il ven, 2004-10-15 alle 00:03, Nilesh Dhawale ha scritto:
> It seems like SQLNumResultCols is not working right in the freeTDS
> ODBC driver. I am on Solaris. The function returns 0 for the number of
> columns in a table which has some columns. Return code is SQL_SUCCESS.
> This happens if the statement is only "prepared", not "executed". I
> tried on 6 different databases on windows and DB2 driver on AIX and
> they all seem to work fine without having to "execute"! I am using
> freetds-0.62.4 odbc driver. Is this a known issue?

Yes, use 0.63. It still do not support getting store procedure
informations. Just an advice if you can use SQLStatistics or if you want
to exec the select call SQLExecute, it's faster (cause you strip an
extra dialog with the server).

> A complete test program is attached. Here is a code snippet that shows
> the problem.
> ...

Very similar to prepare_results.c unit test.

freddy77