Skip site navigation (1) Skip section navigation (2)

[ 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 (view raw or flat)
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

pgsql-odbc by date

Next:From: SAFAK CIRAGDate: 2006-05-10 06:31:14
Subject: libpq pgconn pointer
Previous:From: AndreasDate: 2006-05-10 01:42:18
Subject: Re: Pocket PC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group