Share via

Visual InterDev

  • Article

      

Sets various Microsoft® ActiveX® Data Objects (ADO) connection options for the . These are the same option settings you can make for ADO Command objects in the data environment.

For more information on ADO recordset management, cursor types, and Command objects, see .

Options

Recordset management

Cursor type

Select the type of cursor you want - Dynamic, Forward Only, KeySet, or Static.

If your Scripting Platform setting is Client (IE 4.0 DHTML), Static is the only available setting.

Cursor location

Select the cursor location you want:

Setting Description
None no cursor
Use server-side cursor The cursor is managed by your database server
Use client-side cursor The cursor is managed by your Web server
Use client batch cursor You can update multiple recordsets in a batch

Note   This property setting is only available for ASP pages and if your Scripting Platform setting for this Recordset control is Server (ASP). It is disabled if your Scripting Platform setting is Client (IE 4.0 DHTML).

Lock type

Select the type of record locking you want - Batch Optimistic, Optimistic, Pessimistic, or Read-Only. Pessimistic locking is available only for server-side cursors and only for certain types of databases.

Cache size

Enter the number of records from the recordset that you want to have cached in memory when the recordset is opened. Sets the CacheSize property of the control.

Command configuration

Command timeout

Enter the number of seconds you want to wait before the ADO command contained in this Recordset control times out during execution. The Command objects stored in Recordset controls contain database objects, such as views or stored procedures or explicit SQL statements, that execute ADO commands against the database.

Prepare before execution

Check this box if you want the ADO command contained in this Recordset control to be compiled before it is executed. This is useful, for example, if the command will be executed several times on this page.

Max records

Enter the maximum number of records in the database you want the ADO command contained in this Recordset control to be executed against. Select All records to execute the command against all the records in the database, or enter a number of records in the box to the right. The ADO command will be executed against the number of records you specify, starting with the first record in the recordset.

ODBC specific

ODBC call syntax

Presents the syntax that will be used to call stored procedures in ODBC databases. This setting is read-only.