[freetds] SQL_NO_DATA or SQL_SUCCESS

Peter Deacon peterd at iea-software.com
Sun Feb 24 14:20:49 EST 2008


On Sun, 24 Feb 2008, Frediano Ziglio wrote:

> Hi,
>  often many people let me note that our ODBC driver returns SQL_NO_DATA 
> from SQLExecDirect/SQLExecute instead of SQL_SUCCESS. I always replied 
> that SQL_NO_DATA it's documented and normal. Some days ago however I ask 
> me what the behavior of MS ODBC SQL Server driver... I changed a bit our 
> tests (just in my working directory) in order to print any 
> SQLExecDirect/SQLExecute results and I noted that MS driver NEVER 
> returns SQL_NO_DATA !!! And I have to say that our tests works changing 
> our driver returning SQL_SUCCESS instead of SQL_NO_DATA. So actually I'm 
> thinking about merging this patch.

Imitation always trumps the spec?!  From the MS generic ODBC doc it was 
only supposed to apply to UPDATE/DELETE that change no rows anyway. 
(rowcount == 0)

On another note tried the latest .82 from cvs and it looks good :)

Have Fun!
Peter


More information about the FreeTDS mailing list