Oracle 8.0.4.4 ODBC BUG on PO8

I have a BUG to report - the Oracle 8.0.4.4 connection can crash ( freeze up).

I use one HENV, and multiple HDBC's; I reuse the HDBC's by generating many HSTMT's for each. This allows multiple logins per connection and multiple queries per login - all on same workstation. HOWEVER I have only one HENV, one HDBC and one HSTMT active at any one time. When an HSTMT is deactivated I issue a SQLFreeStmt(... , SQL_DROP); the HDBC's are re-used and only get closed upon program exit with SQLDisconnect() followed by SQLFreeConnect().

The bug is this: if I open n connections (HDBC's) then on closing I can only close n-1 of them; closing the last connection hangs up ODBC on the SQLDisconnect() call. The exception here is a single connection, which causes no problems. The hangup symptoms are that the rest of the system still works but there is no return from the SQLDisconnect() call and no errors are reported (RETCODE).

I use ODBC 2.x function calls (i.e. I use the deprecated form of some) because the program is geared to run multiple vendors concurrently and the norm is ODBC 2.x on 32-bit systems. I am testing under Win 95 against the pre-configured PO8 database.

I cross-checked my own code - it works fine with other vendors' ODBC drivers.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 10 1998 - 17:04:01 CDT