[ psqlodbc-Bugs-1000641 ] odbc can't execute next statement after execute a bad function

Bugs item #1000641, was opened at 2006-05-10 02:51
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000641&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: odbc can't execute next statement after execute a bad function

Initial Comment:
server :8.1.1
odbc   :psqlodbc 8.02.00.02
test tool: odbcte32.exe

after I execute a bad function
   select bad_func()

I can't execute any statement , ODBC 's errmsg is "the cursor is open"

there is odbcte32 's log as below:
--------------------------------------------------------------
            dbc:        szSqlState = "01004", *pfNativeError = 215, *pcbErrorMsg = 27
                                        MessageText = "the ConnStrOut is too small"
Full Connect:

    Full Connect(Default)

    Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3

    Successfully connected to DSN 'PostgreSQL Unicode'.
SQLExecDirect:
                In:                hstmt = 0x00C00394, szSqlStr = "select bad_func()",
                                        cbSqlStr = -3
                Return:    SQL_ERROR=-1

Errors All:
                :        szSqlState = "42P01", *pfNativeError = 7, *pcbErrorMsg = 73
                                        szErrorMsg = "ERROR: relation "notable" does not exist;
Error while executing the query"
                desc:        szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
                                        MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this
function"
                desc:        szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
                                        MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this
function"
                desc:        szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
                                        MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this
function"
                desc:        szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
                                        MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this
function"


SQLExecDirect:
                In:                hstmt = 0x00C00394, szSqlStr = "select * from account",
                                        cbSqlStr = -3
                Return:    SQL_ERROR=-1

Errors All:
                :        szSqlState = "HY010", *pfNativeError = 3, *pcbErrorMsg = 19
                                        szErrorMsg = "The cursor is open."
                desc:        szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
                                        MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this
function"
                desc:        szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
                                        MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this
function"
                desc:        szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
                                        MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this
function"
                desc:        szSqlState = "IM001", *pfNativeError = 0, *pcbErrorMsg = 70
                                        MessageText = "[Microsoft][ODBC Driver Manager] Driver does not support this
function"
--------------------------------------------------------------------------


----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000641&group_id=1000125