Oracle8/NT VB5 Cursor Problem

I've got a VB5 application (using DAO...ODBC Direct) connecting to Oracle 8 for NT. I've set up a DSN using the Oracle driver supplied with the distribution (Oracle ODBC Driver 8.00.0300) and am having the following problems:

When I open a recordset off the connection object, the operation seems to work. When I try to access the recordcount property of the recordset, though, it returns "-1". If I try to use the MoveFirst or MoveLast methods, an error occurs (I think "operation not supported"). If I simply access fields in the recordset (i.e. at whatever record it's at after opening), I'm able to see data (from the first record).

If I look at the ODBC trace, it seems that it's having a problem loading the cursor library:

  DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)

  DIAG [01000] [Microsoft][ODBC Driver Manager] Cursor library not used. Load failed (0)

  DIAG [01000] [Microsoft][ODBC Driver Manager] Cursor library not used. Load failed (0)

For what it's worth, the exact same code works against an Oracle 7 machine.

Is there something on the NT client system which needs to be upgraded to work with Oracle 8? I couldn't find anything in Oracle's documentation, nor could I figure out where to get information about this from there Web Site.

Any ideas would be greatly appreciated.

Mark Hartigan
markhartigan[removebeforesending]@home[removenospam].com Received on Mon Nov 23 1998 - 10:35:41 CST