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

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000641 ] odbc can't execute next statement after execute a bad function
Date: 2006-05-10 02:51:32
Message-ID: 20060510025132.E7F3286C4D8@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Browse pgsql-odbc by date

  From Date Subject
Next Message SAFAK CIRAG 2006-05-10 06:31:14 libpq pgconn pointer
Previous Message Andreas 2006-05-10 01:42:18 Re: Pocket PC