The Microsoft Index Server Provider allows ADO to access ???
Connection Information
Provider-Specific Properties
The Properties collections of the Connection, Command, and Recordset objects include dynamic properties specific to the provider. After establishing the connection and creating these objects, use the Refresh method on the object’s Properties collection to obtain the provider-specific properties.
These properties provide information about functionality specific to the provider beyond the built-in properties ADO supports.
The following tables describe the properties specific to the Microsoft Index Server Provider for OLE DB, listed by their ordinal position (or index) in the Properties collection. For more information about these properties, refer to ???.
Connection object properties:
| Index | Property Name | Index | Property Name |
Command and Recordset object properties:
| Index | Property Name | Index | Property Name |
Recordset Limitations
The following tables list the features available with ADO Recordset objects of different cursor types. All cases assume a Recordset opened on an indexed table with LockType = adLockBatchOptimistic.
Supports method arguments:
| ForwardOnly | Dynamic | Keyset | Static | |
| adAddNew | True | True | True | True |
| adApproxPosition | False | False | False | False |
| adBookmark | False | False | True | True |
| adDelete | True | True | True | True |
| adHoldRecords | False | False | True | True |
| adMovePrevious | False | True | True | True |
| adResync | False | False | True | True |
| adUpdate | True | True | True | True |
| adUpdateBatch | True | True | True | True |
Recordset properties:
| ForwardOnly | Dynamic | Keyset | Static | |
| AbsolutePage | not available | not available | write-only | write-only |
| AbsolutePosition | not available | not available | write-only | write-only |
| ActiveConnection | read/write | read/write | read/write | read/write |
| BOF | read-only | read-only | read-only | read-only |
| Bookmark | not available | not available | read/write | read/write |
| CacheSize | read/write | read/write | read/write | read/write |
| CursorType | read/write | read/write | read/write | read/write |
| EditMode | read-only | read-only | read-only | read-only |
| EOF | read-only | read-only | read-only | read-only |
| Filter | read/write | read/write | read/write | read/write |
| LockType | read/write | read/write | read/write | read/write |
| MaxRecords | read/write | read/write | read/write | read/write |
| PageCount | not available | not available | read-only | read-only |
| PageSize | read/write | read/write | read/write | read/write |
| RecordCount | not available | not available | read-only | read-only |
| Source | read/write | read/write | read/write | read/write |
| Status | read-only | read-only | read-only | read-only |
Recordset methods:
| ForwardOnly | Dynamic | Keyset | Static | |
| AddNew | Yes | Yes | Yes | Yes |
| CancelUpdate | Yes | Yes | Yes | Yes |
| CancelBatch | Yes | Yes | Yes | Yes |
| Clone | No | No | Yes | Yes |
| Close | Yes | Yes | Yes | Yes |
| Delete | Yes | Yes | Yes | Yes |
| GetRows | Yes | Yes | Yes | Yes |
| Move | Yes | Yes | Yes | Yes |
| MoveFirst | Yes | Yes | Yes | Yes |
| MoveLast | No | No | Yes | Yes |
| MovePrevious | No | Yes | Yes | Yes |
| Open | Yes | Yes | Yes | Yes |
| Requery | Yes | Yes | Yes | Yes |
| Resync | No | No | Yes | Yes |
| Supports | Yes | Yes | Yes | Yes |
| Update | Yes | Yes | Yes | Yes |
| UpdateBatch | Yes | Yes | Yes | Yes |
Notes:
While it is possible to request batch updating in conjuction with forward-only and dynamic cursors, you are currently prevented from updating more than one row at a time. You should therefore only use batch updating with keyset and static cursors, i.e. where both rstTemp.Supports(adUpdateBatch) and rstTemp.Supports(adHoldRecords) are True.
Error Messages
For infomation about error messages generated by the Microsoft Index Server Provider for OLE DB, see the ????.
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.