| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
