Re: SQLEndTran(henv) returns SQL_SUCCESS for HY010

Nick,
    Did you check if SQLEndTran(henv) is returning HY010 in case of S11
: SQL_STILL_EXECUTING ??
I am seeing SQL_SUCCESS. 

-----------------------------------------------------
[ODBC][26479][1246275063.735329][SQLColumns.c][215]
                Entry:
                        Statement = 0x456e18
                        Catalog Name = [NULL]
                        Schema Name = [NULL]
                        Table Name = [NULL]
                        Column Name = [NULL]
[ODBC][26479][1246275064.230182][SQLColumns.c][412]
                Exit:[SQL_STILL_EXECUTING]
[ODBC][26479][1246275064.230239][SQLError.c][352]
                Entry:
                        Statement = 0x456e18
                        SQLState = 0x7faa864e
                        Native = 0x7faa8750
                        Message Text = 0x7faa854e
                        Buffer Length = 256
                        Text Len Ptr = 0x7faa874e
[ODBC][26479][1246275064.230262][SQLError.c][389]
                Exit:[SQL_NO_DATA]
[ODBC][26479][1246275064.230313][SQLEndTran.c][252]
                Entry:
                        Environment = 0x403090
                        Completion Type = 0
[ODBC][26479][1246275064.419749][SQLEndTran.c][402]
                Exit:[SQL_SUCCESS]
-----------------------------------------------------

Can you confirm on this..

Thanks
Hemanth.
 

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of G,
Hemanth Kumar
Sent: Monday, June 29, 2009 4:15 PM
To: Development issues and topics for unixODBC
Subject: Re: [unixODBC-dev] SQLEndTran(henv) returns SQL_SUCCESS for
HY010

It works perfect.. 
Sorry again :)



-----Original Message-----
From: [email protected]
[mailto:[email protected]] 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
> [email protected]
> 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
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev