Microsoft ODBC Provider for OLE DB

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.