[unixODBC-dev] SQLEndTran(henv) returns SQL_SUCCESS for HY010

[Nick Gorham]

G, Hemanth Kumar wrote:
> Hi Nick,
>
>       When SQLExecute returns SQL_NEED_DATA, following it, SQLEndTran
> with environment handle must return HY010 (Function sequence error).
> Instead, returns SQL_SUCCESS.
>
> SQLExecute() -> SQL_NEED_DATA
> SQLEndTran(SQL_HANDLE_ENV, henv, SQL_COMMIT);
> Expected : HY010
> Received : SQL_SUCCESS
>
> Please check this.
>
> Thanks
> Hemanth 
>
> _______________________________________________
> unixODBC-dev mailing list
> unixODBC-dev at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
>   
It seems to work here.

[ODBC][2921][1246268887.022085][SQLExecDirect.c][240]
        Entry:
            Statement = 0x813a238
            SQL = [insert into ntest11 values( ? )][length = 31 (SQL_NTS)]
[ODBC][2921][1246268887.022979][SQLExecDirect.c][503]
        Exit:[SQL_NEED_DATA]
[ODBC][2921][1246268887.025256][SQLEndTran.c][252]
        Entry:
            Environment = 0x8127090
            Completion Type = 0
[ODBC][2921][1246268887.025324][SQLEndTran.c][307]Error: HY010

-- 
Nick