13.7 Setting cursor libraries

A cursor library must be set before SQLExtendedFetch can be used in an ODBC UAP. A cursor library can be set in two ways:

When the SetConnectOption ODBC function is used:
Use the SetConnectOption ODBC function and specify SQL_ODBC_CURSORS in the fOption argument and SQL_CUR_USE_ODBC in the vParam argument.
When RDO of Visual Basic is used:
Specify rdUseOdbc in the CursorDriver property of the rdoEnvironment object. The following is an example of coding when RDO of Visual Basic is used:

Dim mrdoEnv as rdoEnvironment
Set mrdoEnv = rdoEngine.rdoCreateEnvironment("","","")
   mrdoEnv.CursorDriver = rdUseOdbc
   Src = "DSN=host1; UID=USER_A;PWD=USER_A"
   Set mrdoConn = mrdoEnv.OpenConnection
                  ("", rdDriverComplete, False, Src)
       ...
       ...

See the simple sample UAPs found in the Sampleap directory of the installation floppy disk for the ODBC driver.