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.