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

[G, Hemanth Kumar]

It works perfect.. 
Sorry again :)



-----Original Message-----
From: unixodbc-dev-bounces at mailman.unixodbc.org
[mailto:unixodbc-dev-bounces at mailman.unixodbc.org] On Behalf Of Nick
Gorham
Sent: Monday, June 29, 2009 3:20 PM
To: Development issues and topics for unixODBC
Subject: Re: [unixODBC-dev] SQLEndTran(henv) returns SQL_SUCCESS for
HY010

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
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev at mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev