Server-Side Cursor - OLE DB Provider for Teradata

Server-Side Cursor

The consumer specifies server-side cursors by setting the Cursor Location property of the connection object to adUseServer.

The server side cursor is maintained by Teradata Database. As stated in “Teradata Database Limitations” on page 109, Teradata supports only static cursors that only move forward. Therefore, the only supported Cursor Type property value is adOpenForwardOnly. If the Cursor Type property is any other value (adOpenKeyset, adOpenDynamic, adOpenStatic) OLE DB Provider for Teradata uses adOpenFowardOnly instead. ADO does the substitution. OLE DB Provider for Teradata does not return an error when the recordset object is opened.

For information on CursorLocation and CursorType properties, refer to the MSDN documentation.

MSDN Library - Go to http://msdn.microsoft.com/library/

Data Access

Microsoft Data Access Components

SDK Documentation

Microsoft ActiveX Data Objects (ADO)

ADO Programmer’s Guide

ADO API Reference

ADO Properties