Home » Infrastructure » Windows » Oracle becomes unresponsive when fetching rows through ODBC
Oracle becomes unresponsive when fetching rows through ODBC [message #101103] Mon, 03 May 2004 12:23
Eric
Messages: 78
Registered: April 1999
Member
I'm having a problem where while executing a SELECT statement, ODBC is failing to return from a call to SQLExtendedFetch.

Examining the database while in this state does not show any locks being held. Additionally, the select is not trying to update the database, it is just scanning a table and should not be getting blocked. ODBC operations in other threads, both select and updates, even on the same table, continue to work.

The application is running on NT 4.0sp6 with MDAC 2.8 and Oracle ODBC driver 8.1.7.8.10. The database is Oracle 8.1.7.3 on RedHat Linux.

Any ideas on what might be causing the fetch to not return or what more I can look at in the database would greatly appreciated.

Thank you,
- Eric
Previous Topic: How do I restore icons?
Next Topic: Dos Operating System Related Problem
Goto Forum:
  


Current Time: Thu Mar 28 19:18:00 CDT 2024