Search Again: Oracle9 ODBC Driver problem From: Congjin Lu Date: Thursday, December 11, 2003 Time: 12:14:04 pm Hi, I did a simple test below. When I used Oracle9 ODBC drvier 9.2.0.2.0, I can successfully move cursor to the first row. However when I used any later Oracle9 ODBC driver (up to latest 9.2.0.5.4), the system hangs at SQLFetchScroll(). Can any expert here give me a help to solve this problem? Thank you very much. ================================ Oracle9 database: 9.2.0.1.0 Operating system: Windows XP Oracle9 ODBC drvier: 9.2.0.2.0 (working) Oracle9 ODBC drvier: 9.2.0.3.0 or later (Hanging forever) ================================ CREATE TABLE MYTABLE (ID VARCHAR2(10) NOT NULL, VARTEXT VARCHAR2(100 char), LONGTEXT CLOB, CONSTRAINT IKEY PRIMARY KEY(ID)); INSERT INTO MYTABLE (ID ,VARTEXT) VALUES ('123' ,'Add VARCHAR text first. Then query this record and bind all columns.'); select ID, VARTEXT, LONGTEXT from MYTABLE; SQLSetStmtAttr: In: StatementHandle = 0x00ef2bd8, Attribute = SQL_ATTR_CURSOR_TYPE=6, ValuePtr = SQL_CURSOR_KEYSET_DRIVEN=1, StringLength = SQL_IS_INTEGER=-6, fAttribute Type = SQL_C_SLONG=-16 Return: SQL_SUCCESS=0 SQLExecDirect: In: Statementhandle = 0x00ef2bd8, StatementText = "select ID, VARTEXT, LONGTEXT from MYTABLE;", Statementlength = 48 Return: SQL_SUCCESS=0 SQLBindCol: In: StatementHandle = 0x00ef2bd8, ColumnNumber = 1, TargetType = SQL_C_WCHAR=-8, TargetValuePtr = 0x02159ccc, BufferLength = 10, StrLen_or_IndPtr = 0x02159c80 (value = 0) Return: SQL_SUCCESS=0 SQLBindCol: In: StatementHandle = 0x00ef2bd8, ColumnNumber = 2, TargetType = SQL_C_WCHAR=-8, TargetValuePtr = 0x0215a1f0, BufferLength = 100, StrLen_or_IndPtr = 0x0215a120 (value = 0) Return: SQL_SUCCESS=0 SQLBindCol: In: StatementHandle = 0x00ef2bd8, ColumnNumber = 3, TargetType = SQL_C_WCHAR=-8, TargetValuePtr = 0x00000002, BufferLength = 0, StrLen_or_IndPtr = 0x0215af30 (value = 0) Return: SQL_SUCCESS=0 SQLFetchScroll: In: StatementHandle = 0x00ef2bd8, FetchOrientation = SQL_FETCH_FIRST=2, FetchOffset = 0 Return: SQL_SUCCESS_WITH_INFO=1 ---------------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.digitalpoint.com/lists/oracle.html ----------------------------------------------------------

Messages In This Thread: Oracle9 ODBC Driver problem by Congjin Lu on Dec 11, 2003 at 12:14:04 pm