The Microsoft ODBC Provider allows ADO to connect to any ODBC data source.
Connection Parameters
In addition to the 5 standard connection parameters recognized by the ADO ConectionString property, the Microsoft ODBC Provider for OLE DB also recognizes the following connection parameters. These parameters are not evaluated by ADO, but instead are passed through to the provider.
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 ODBC Provider for OLE DB, listed by their ordinal position (or index) in the Properties collection. For more information about these properties, refer to the OLE DB Programmer’s Reference.
Connection object properties specific to the Microsoft ODBC Provider for OLE DB:
| Index | Property Name | Index | Property Name |
| 0 | Password | 42 | Prepare Commit Behavior |
| 1 | Persist Security Info | 43 | Procedure Term |
| 2 | User ID | 44 | Provider Name |
| 3 | Data Source | 45 | OLE DB Version |
| 4 | Window Handle | 46 | Provider Version |
| 5 | Locale Identifier | 47 | Quoted Identifier Sensitivity |
| 6 | Location | 48 | Rowset Conversions on Command |
| 7 | Mode | 49 | Schema Term |
| 8 | Prompt | 50 | Schema Usage |
| 9 | Extended Properties | 51 | SQL Support |
| 10 | Connect Timeout | 52 | Structured Storage |
| 11 | Active Sessions | 53 | Subquery Support |
| 12 | Asynchable Abort | 54 | Transaction DDL |
| 13 | Asynchable Commit | 55 | Isolation Levels |
| 14 | Pass By Ref Accessors | 56 | Isolation Retention |
| 15 | Catalog Location | 57 | Table Term |
| 16 | Catalog Term | 58 | User Name |
| 17 | Catalog Usage | 59 | Current Catalog |
| 18 | Column Definition | 60 | Accessible Procedures |
| 19 | NULL Concatenation Behavior | 61 | Accessible Tables |
| 20 | Data Source Name | 62 | Driver Name |
| 21 | Read-Only Data Source | 63 | Driver Version |
| 22 | DBMS Name | 64 | Driver ODBC Version |
| 23 | DBMS Version | 65 | File Usage |
| 24 | Data Source Object Threading Model | 66 | Like Escape Clause |
| 25 | GROUP BY Support | 67 | Max Columns in Group By |
| 26 | Heterogenous Table Support | 68 | Max Columns in Index |
| 27 | Identifier Case Sensitivity | 69 | Max Columns in Order By |
| 28 | Maximum Index Size | 70 | Max Columns in Select |
| 29 | Maximum Row Size | 71 | Max Columns in Table |
| 30 | Maximum Row Size Includes BLOB | 72 | Numeric Functions |
| 31 | Maximum Tables in SELECT | 73 | Integrity Enhancement Facility |
| 32 | Multiple Parameter Sets | 74 | SQL Grammar Support |
| 33 | Multiple Results | 75 | Outer Join Capabilities |
| 34 | Multiple Storage Objects | 76 | Outer Joins |
| 35 | Multi-Table Update | 77 | Stored Procedures |
| 36 | NULL Collation Order | 78 | Special Characters |
| 37 | OLE Object Support | 79 | String Functions |
| 38 | ORDER BY Columns in Select List | 80 | System Functions |
| 39 | Output Parameter Availability | 81 | Time/Date Functions |
| 40 | Persistent ID Type | 82 | Active Statements |
| 41 | Prepare Abort Behavior |
Command and Recordset object properties specific to the Microsoft ODBC Provider for OLE DB:
| Index | Property Name | Index | Property Name |
| 0 | IAccessor | 35 | Column Set Notification |
| 1 | IColumnsInfo | 36 | Row Activate Notification |
| 2 | IColumnsRowset | 37 | Row Delete Notification |
| 3 | IConnectionPointContainer | 38 | Row First Change Notification |
| 4 | IConvertType | 39 | Row Insert Notification |
| 5 | IRowset | 40 | Row Release Notification |
| 6 | IRowsetChange | 41 | Row Resynchronization Notification |
| 7 | IRowsetIdentity | 42 | Rowset Release Notification |
| 8 | IRowsetInfo | 43 | Rowset Fetch Position Change Notification |
| 9 | Bookmarkable | 44 | Row Undo Change Notification |
| 10 | IRowsetResynch | 45 | Row Undo Delete Notification |
| 11 | IRowsetUpdate | 46 | Row Undo Insert Notification |
| 12 | ISupportErrorInfo | 47 | Row Update Notification |
| 13 | ISequentialStream | 48 | Others' Inserts Visible |
| 14 | Preserve on Abort | 49 | Others' Changes Visible |
| 15 | Blocking Storage Objects | 50 | Own Inserts Visible |
| 16 | Include Bookmark Data | 51 | Own Changes Visible |
| 17 | Skip Deleted Bookmarks | 52 | Quick Restart |
| 18 | Bookmark Type | 53 | Reentrant Events |
| 19 | Fetch Backwards | 54 | Remove Deleted Rows |
| 20 | Hold Rows | 55 | Report Multiple Changes |
| 21 | Scroll Backwards | 56 | Return Pending Inserts |
| 22 | Change Inserted Rows | 57 | Row Privileges |
| 23 | Column Privileges | 58 | Row Threading Model |
| 24 | Command Time Out | 59 | Server Cursor |
| 25 | Preserve on Commit | 60 | Strong Row Identity |
| 26 | Delay Storage Object Updates | 61 | Objects Transacted |
| 27 | Immobile Rows | 62 | Updatability |
| 28 | Literal Bookmarks | 63 | Query Based Updates/Deletes/Inserts |
| 29 | Literal Row Identity | 64 | Generate a Rowset that can be marshalled |
| 30 | Maximum Open Rows | 65 | Position on the last row after insert |
| 31 | Maximum Pending Rows | 66 | IRowsetChangeExtInfo |
| 32 | Maximum Rows | 67 | ODBC Cursor Type |
| 33 | Notification Phases | 68 | ODBC Concurrency Type |
| 34 | Column Recalculated Notification | 69 | BLOB accessibility on Forward-Only cursor |
Recordset Limitations
The following tables list the features available with ADO Recordset objects of different cursor types when you use the Microsoft ODBC Provider for OLE DB. 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 supported by the Microsoft ODBC Provider for OLE DB.
| 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 supported by the Microsoft ODBC Provider for OLE DB.
| 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.
The IRowsetScroll interface is not implemented in version 1.0 of the ODBC Provider for OLE DB. As a result the AbsolutePosition and AbsolutePage properties are write-only. Also, these properties require bookmarks.
Error Messages
The following error infomation is generated by the Microsoft ODBC Provider for OLE DB, and exposed through the ADO Errors collection.
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.