CONTENTS
Up to Level
Microsoft Data Access Components
What's New in the MDAC SDK
Changes and Enhancements in MDAC 2.6
MDAC Release Manifest
Navigating the MDAC Documentation
Locating MDAC Components
Using MDAC Resources
MDAC Documentation
User Interface Help
MDAC Samples
Web Sites
Microsoft Knowledge Base Articles
Printed Resources
MDAC Distribution, Past and Present
MDAC Background
How MDAC Is Distributed
MDAC Component Breakdown
ODBC
OLE DB
ActiveX Data Objects (ADO)
Other Components
MDAC Version History
MDAC 1.0
MDAC 1.5
MDAC 2.0
MDAC 2.1
MDAC 2.5
MDAC Release Timeline
Redistributing MDAC
Troubleshooting
Getting Help from Microsoft Product Support Services
Do You Have Feedback About MDAC Documentation?
MDAC Copyright and Legal Information
Microsoft ActiveX Data Objects (ADO)
ADO Programmer's Guide
Introduction
What's New in ADO
Prerequisites
The ADO Family of Libraries
The Role of ADO in Universal Data Access
Referencing the ADO Libraries
Installing and Redistributing ADO
ADO Task Table
ADO Technology Table
Section I: ActiveX Data Objects (ADO)
Chapter 1: ADO Fundamentals
What You Can Do With ADO
The ADO Object Model
HelloData: A Simple ADO Application
Hello Data Details
Hello Data Code
OLE DB Providers
Data Providers
Service Providers and Components
Errors
Chapter 2: Getting Data
Making a Connection
Using the Connection Object
Creating the Connection String
Controlling Transactions
Using the Command Object
Command Object Overview
Creating and Executing a Simple Command
Command Object Parameters
Calling a Stored Procedure with a Command
Named Commands
Adding Data to a Recordset
The Recordset Object Open Method
Source and Options Arguments
ActiveConnection Argument
CursorType Argument
LockType Argument
Retrieving Multiple Recordsets
Chapter 3: Examining Data
Locating the Current Record
Counting Rows
The Limits of a Recordset
Navigating Through the Data
Jumping to a Record
More Ways to Move in a Recordset
Using Bookmarks
Using Pages
Recordset Positioning
Understanding Recordset Structure
The Fields Collection
Examining the Fields Collection
Counting Columns
Getting to the Field
Using the Refresh Method
Adding Fields to a Recordset
The Field Object
Describing a Field
Discovering the Data Type
Determining Field Size
Determining Field Contents
Getting More Field Information
Dealing with Binary Data
Working with Recordsets
Arranging Data
Finding a Specific Record
Filtering the Results
Filtering with a Criteria String
Filtering with a Constant
Filtering with Bookmarks
Creating a Clone of a Recordset
Chapter 4: Editing Data
Editing Existing Records
Adding Records
Adding Records Using AddNew
Adding Multiple Fields
Determining Edit Mode
Using AddNew in Immediate and Batch Modes
Determining What is Supported
Deleting Records Using the Delete Method
Alternatives: Using SQL Statements
Chapter 5: Updating and Persisting Data
Updating Data
Immediate Mode
Batch Mode
Sending the Updates: UpdateBatch
Filtering for Updated Records
Dealing with Failed Updates
Detecting and Resolving Conflicts
Disconnecting and Reconnecting the Recordset
Updating JOINed Results: Unique Table
Transaction Processing
Persisting Data
More About Recordset Persistence
Persisting Filtered and Hierarchical Recordsets
Persisting Records in XML Format
XML Persistence Format
Namespaces
Schema Section
Data Section
Hierarchical Recordsets in XML
Recordset Dynamic Properties in XML
XSL Transformations
Saving to the XML DOM
XML Security Considerations
XML Recordset Persistence Scenario
Step 1: Set Up the Application
Step 2: Get the Data
Step 3: Send the Data
Step 4: Receive and Display the Data
Chapter 6: Error Handling
ADO Errors
ADO Error Reference
Provider Errors
Field-Related Error Information
Recordset-Related Error Information
Handling Errors In Other Languages
Handling Errors in VBScript
Handling Errors in Visual C++
Handline Errors in Visual J++
Handling Errors in JScript
Anticipating Errors
Chapter 7: Handling ADO Events
ADO Event Handler Summary
Types of Events
Event Parameters
How Event Handlers Work Together
ADO Event Instantiation by Language
Visual Basic
Visual C++
Visual J++
VBScript
JScript
ADO/WFC
Chapter 8: Understanding Cursors and Locks
What is a Cursor?
Types of Cursors
Forward-Only Cursors
Static Cursors
Keyset Cursors
Dynamic Cursors
The Significance of Cursor Location
The Microsoft Cursor Service for OLE DB
What is a Lock?
Types of Locks
Using CacheSize
Cursor and Lock Characteristics
Chapter 9: Data Shaping
Data Shaping Summary
Data Shaping
Reshaping
Grandchild Aggregates
Parameterized Commands with Intervening COMPUTE Commands
Persisting Hierarchical Recordsets
Required Providers for Data Shaping
Shape Commands in General
Aggregate Functions, the CALC Function, and the NEW Keyword
Issuing Commands to the Underlying Data Provider
Shape Append Clause
Operation of Non-Parameterized Commands
Operation of Parameterized Commands
Hybrid Commands
Intervening Shape COMPUTE Clauses
Shape Compute Clause
Fabricating Hierarchical Recordsets
Accessing Rows in a Hierarchical Recordset
Formal Shape Grammar
Visual Basic for Applications Functions
Chapter 10: Records and Streams
Streams and Persistence
CommandStreams
Retrieving Resultsets into Streams
Using ADO for Internet Publishing
The OLE DB Provider for Internet Publishing
Internet Publishing Scenario
Step 1: Set Up the Visual Basic Project
Step 2: Initialize the Main List Box
Step 3: Populate the Fields List Box
Step 4: Populate the Details Text Box
Absolute and Relative URLs
Records and Provider-Supplied Fields
Section II: Remote Data Service (RDS)
Chapter 11: RDS Fundamentals
Solutions for Remote Data Access
Basic RDS Programming Model
RDS Programming Model in Detail
RDS Programming Model with Objects
RDS Object Model Summary
RDS Scenario
System Requirements for the Address Book Application
Running the Address Book SQL Script
Running the Address Book Sample Application
Address Book Data-Binding Object
Address Book Command Buttons
Address Book Navigation Buttons
Chapter 12: RDS Tutorial
Step 1: Specify a Server Program (RDS Tutorial)
Step 2: Invoke the Server Program (RDS Tutorial)
Step 3: Server Obtains a Recordset (RDS Tutorial)
Step 4: Server Returns the Recordset (RDS Tutorial)
Step 5: DataControl is Made Usable (RDS Tutorial)
Step 6: Changes are Sent to the Server (RDS Tutorial)
RDS Tutorial (VBScript)
RDS Tutorial (Visual J++)
Chapter 13: RDS Usage and Security
Configuring RDS
Granting Guest Privileges to a Web Server Computer
Registering a Custom Business Object
Marking Business Objects as Safe for Scripting
Registering Business Objects on the Client for Use with DCOM
Setting DCOM Stream Marshaling Format
Enabling a DLL to Run on DCOM
Configuring Virtual Servers on IIS
Specifying Threads Per Processor on IIS
Securing RDS Applications
Configuring DataFactory for Safe or Unrestricted Modes
Using Related Technologies with RDS
Using RDS with ODBC Connection Pooling
Running Business Objects in Component Services
DataFactory Customization
Understanding the Customization File
Customization File Connect Section
Customization File SQL Section
Customization File UserList Section
Customization File Logs Section
Required Client Settings
Writing Your Own Customized Handler
Troubleshooting RDS
Configuring RDS on Windows 2000
"Internet Server Error: Access Denied"
RDS Returns "Stream Not Read" Error
Deadlocks With Read Repeatable Isolation Level
Ensuring Sufficient TempDB Space
Minimizing Log File Space Usage
Section III: ADO (Multidimensional) (ADO MD)
Chapter 14: ADO MD Fundamentals
Overview of Multidimensional Schemas and Data
Working with Multidimensional Data
Using ADO with ADO MD
Programming with ADO MD
Section IV: ADO Extensions for Data Definition Language and Security (ADOX)
Chapter 15: ADOX Fundamentals
Provider Support for ADOX
Section V: Appendixes
Appendix A: Providers
Microsoft OLE DB Provider for ODBC
Microsoft OLE DB Provider for Microsoft Indexing Service
Microsoft OLE DB Provider for Microsoft Active Directory Service
Microsoft OLE DB Provider for Microsoft Jet
Microsoft OLE DB Provider for SQL Server
Microsoft OLE DB Provider for Oracle
Microsoft OLE DB Provider for Internet Publishing
Microsoft Data Shaping Service for OLE DB (ADO Service Provider)
Microsoft OLE DB Persistence Provider (ADO Service Provider)
Microsoft OLE DB Remoting Provider (ADO Service Provider)
Microsoft Cursor Service for OLE DB (ADO Service Component)
Microsoft OLE DB Simple Provider
Appendix B: ADO Errors
ADO Error Codes
DataControl Error Codes
Internet Explorer Error Codes
Internet Information Services Error Codes
Appendix C: Programming with ADO
Using ADO with Microsoft Visual Basic
Using ADO with Scripting Languages
VBScript ADO Programming
JScript ADO Programming
Using ADO with Microsoft Visual C++
Visual C++ ADO Programming
Visual C++ Extensions for ADO
Using Visual C++ Extensions
Visual C++ Extensions Header
Visual C++ Extensions Example
Using ADO with Microsoft Visual J++
ADO/WFC Programming
Using the Java Type Library Wizard
Using the Microsoft SDK for Java
ADO Java Class Wrappers
Appendix D: ADO Samples
Sample Applications
ADO Glossary
ADO Programmer's Reference
ADO API Reference
ADO Object Model
ADO Objects
Command Object (ADO)
Properties, Methods, and Events
Connection Object (ADO)
Properties, Methods, and Events
Error Object (ADO)
Properties, Methods, and Events
Field Object (ADO)
Properties, Methods, and Events
Parameter Object (ADO)
Properties, Methods, and Events
Property Object (ADO)
Properties, Methods, and Events
Record Object (ADO)
Properties, Methods, and Events
Recordset Object (ADO)
Properties, Methods, and Events
Stream Object (ADO)
Properties, Methods, and Events
ADO Collections
Errors Collection (ADO)
Errors Collection Properties, Methods, and Events
Fields Collection (ADO)
Fields Collection Properties, Methods, and Events
Parameters Collection (ADO)
Parameters Collection Properties, Methods, and Events
Properties Collection (ADO)
Properties Collection Properties, Methods, and Events
ADO Properties
AbsolutePage Property (ADO)
AbsolutePosition Property (ADO)
ActiveCommand Property (ADO)
ActiveConnection Property (ADO)
ActualSize Property (ADO)
Attributes Property (ADO)
BOF, EOF Properties (ADO)
Bookmark Property (ADO)
CacheSize Property (ADO)
Charset Property (ADO)
CommandStream Property (ADO)
CommandText Property (ADO)
CommandTimeout Property (ADO)
CommandType Property (ADO)
ConnectionString Property (ADO)
ConnectionTimeout Property (ADO)
Count Property (ADO)
CursorLocation Property (ADO)
CursorType Property (ADO)
DataMember Property (ADO)
DataSource Property (ADO)
DefaultDatabase Property (ADO)
DefinedSize Property (ADO)
Description Property (ADO)
Dialect Property (ADO)
Direction Property (ADO)
EditMode Property (ADO)
EOS Property (ADO)
Filter Property (ADO)
HelpContext, HelpFile Properties (ADO)
Index Property (ADO)
IsolationLevel Property (ADO)
Item Property (ADO)
LineSeparator Property (ADO)
LockType Property (ADO)
MarshalOptions Property (ADO)
MaxRecords Property (ADO)
Mode Property (ADO)
Name Property (ADO)
NamedParameters Property (ADO)
NativeError Property (ADO)
Number Property (ADO)
NumericScale Property (ADO)
OriginalValue Property (ADO)
PageCount Property (ADO)
PageSize Property (ADO)
ParentURL Property (ADO)
Position Property (ADO)
Precision Property (ADO)
Prepared Property (ADO)
Provider Property (ADO)
RecordCount Property (ADO)
RecordType Property (ADO)
Size Property (ADO)
Size Property (ADO Stream)
Sort Property (ADO)
Source Property (ADO Error)
Source Property (ADO Record)
Source Property (ADO Recordset)
SQLState Property (ADO)
State Property (ADO)
Status Property (ADO Field)
Status Property (ADO Recordset)
StayInSync Property (ADO)
Type Property (ADO)
Type Property (ADO Stream)
UnderlyingValue Property (ADO)
Value Property (ADO)
Version Property (ADO)
ADO Dynamic Properties
ADO Dynamic Property Index
Optimize Property--Dynamic (ADO)
Prompt Property--Dynamic (ADO)
Reshape Name Property--Dynamic (ADO)
Resync Command Property--Dynamic (ADO)
Unique Table, Unique Schema, Unique Catalog Properties--Dynamic (ADO)
Update Resync Property--Dynamic (ADO)
ADO Methods
AddNew Method (ADO)
Append Method (ADO)
AppendChunk Method (ADO)
BeginTrans, CommitTrans, and RollbackTrans Methods (ADO)
Cancel Method (ADO)
CancelBatch Method (ADO)
CancelUpdate Method (ADO)
Clear Method (ADO)
Clone Method (ADO)
Close Method (ADO)
CompareBookmarks Method (ADO)
CopyRecord Method (ADO)
CopyTo Method (ADO)
CreateParameter Method (ADO)
Delete Method (ADO Parameters Collection)
Delete Method (ADO Fields Collection)
Delete Method (ADO Recordset)
DeleteRecord Method (ADO)
Execute Method (ADO Command)
Execute Method (ADO Connection)
Find Method (ADO)
Flush Method (ADO)
GetChildren Method (ADO)
GetChunk Method (ADO)
GetRows Method (ADO)
GetString Method (ADO)
LoadFromFile Method (ADO)
Move Method (ADO)
MoveFirst, MoveLast, MoveNext, and MovePrevious Methods (ADO)
MoveRecord Method (ADO)
NextRecordset Method (ADO)
Open Method (ADO Connection)
Open Method (ADO Record)
Open Method (ADO Recordset)
Open Method (ADO Stream)
OpenSchema Method (ADO)
Read Method (ADO)
ReadText Method (ADO)
Refresh Method (ADO)
Requery Method (ADO)
Resync Method (ADO)
Save Method (ADO)
SaveToFile Method (ADO)
Seek Method (ADO)
SetEOS Method (ADO)
SkipLine Method (ADO)
Supports Method (ADO)
Update Method (ADO)
UpdateBatch Method (ADO)
Write Method (ADO)
WriteText Method (ADO)
ADO Events
BeginTransComplete, CommitTransComplete, and RollbackTransComplete Events (ADO)
ConnectComplete and Disconnect Events (ADO)
EndOfRecordset Event (ADO)
ExecuteComplete Event (ADO)
FetchComplete Event (ADO)
FetchProgress Event (ADO)
InfoMessage Event (ADO)
WillChangeField and FieldChangeComplete Events (ADO)
WillChangeRecord and RecordChangeComplete Events (ADO)
WillChangeRecordset and RecordsetChangeComplete Events (ADO)
WillConnect Event (ADO)
WillExecute Event (ADO)
WillMove and MoveComplete Events (ADO)
ADO Enumerated Constants
ADCPROP_ASYNCTHREADPRIORITY_ENUM
ADCPROP_AUTORECALC_ENUM
ADCPROP_UPDATECRITERIA_ENUM
ADCPROP_UPDATERESYNC_ENUM
AffectEnum
BookmarkEnum
CommandTypeEnum
CompareEnum
ConnectModeEnum
ConnectOptionEnum
ConnectPromptEnum
CopyRecordOptionsEnum
CursorLocationEnum
CursorOptionEnum
CursorTypeEnum
DataTypeEnum
EditModeEnum
ErrorValueEnum
EventReasonEnum
EventStatusEnum
ExecuteOptionEnum
FieldEnum
FieldAttributeEnum
FieldStatusEnum
FilterGroupEnum
GetRowsOptionEnum
IsolationLevelEnum
LineSeparatorsEnum
LockTypeEnum
MarshalOptionsEnum
MoveRecordOptionsEnum
ObjectStateEnum
ParameterAttributesEnum
ParameterDirectionEnum
PersistFormatEnum
PositionEnum
PropertyAttributesEnum
RecordCreateOptionsEnum
RecordOpenOptionsEnum
RecordStatusEnum
RecordTypeEnum
ResyncEnum
SaveOptionsEnum
SchemaEnum
SearchDirectionEnum
SeekEnum
StreamOpenOptionsEnum
StreamReadEnum
StreamTypeEnum
StreamWriteEnum
StringFormatEnum
XactAttributeEnum
ADO Syntax Indexes
ADO for Visual C++ Syntax Index for COM
Collections (ADO for Visual C++ Syntax)
Command (ADO for Visual C++ Syntax)
Connection (ADO for Visual C++ Syntax)
Error (ADO for Visual C++ Syntax)
Field (ADO for Visual C++ Syntax)
Parameter (ADO for Visual C++ Syntax)
Record (ADO for Visual C++ Syntax)
Recordset (ADO for Visual C++ Syntax)
Stream (ADO for Visual C++ Syntax)
ADO for Visual C++ Syntax Index with #import
Collections (Visual C++ Syntax Index with #import)
Command (Visual C++ Syntax Index with #import)
Connection (Visual C++ Syntax Index with #import)
Error (Visual C++ Syntax Index with #import)
Field (Visual C++ Syntax Index with #import)
Parameter (Visual C++ Syntax Index with #import)
Property (Visual C++ Syntax Index with #import)
Record (Visual C++ Syntax Index with #import)
Recordset (Visual C++ Syntax Index with #import)
Stream (Visual C++ Syntax Index with #import)
ConnectionEvents (Visual C++ Syntax Index with #import)
RecordsetEvents (Visual C++ Syntax Index with #import)
ADO/WFC Syntax Index
Collections (ADO/WFC Syntax)
Command (ADO/WFC Syntax)
Connection (ADO/WFC Syntax)
DataSpace (ADO/WFC Syntax)
Error (ADO/WFC Syntax)
Field (ADO/WFC Syntax)
ObjectProxy (ADO/WFC Syntax)
Parameter (ADO/WFC Syntax)
Recordset (ADO/WFC Syntax)
ADO Code Examples
ADO Code Examples in Microsoft Visual Basic
AbsolutePage, PageCount, and PageSize Properties Example (VB)
AbsolutePosition and CursorLocation Properties Example (VB)
ActiveCommand Property Example (VB)
ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example (VB)
ActualSize and DefinedSize Properties Example (VB)
AddNew Method Example (VB)
Append and CreateParameter Methods Example (VB)
AppendChunk and GetChunk Methods Example (VB)
Attributes and Name Properties Example (VB)
BeginTrans, CommitTrans, and RollbackTrans Methods Example (VB)
BOF, EOF, and Bookmark Properties Example (VB)
CacheSize Property Example (VB)
Cancel Method Example (VB)
Clone Method Example (VB)
CompareBookmarks Method Example (VB)
ConnectionString, ConnectionTimeout, and State Properties Example (VB)
ConvertToString Method Example (VB)
CopyRecord, CopyTo, and SaveToFile Methods Example (VB)
Count Property Example (VB)
CreateRecordset Method Example (VB)
CursorType, LockType, and EditMode Properties Example (VB)
Delete Method Example (VB)
DeleteRecord and MoveRecord Methods Example (VB)
Description, HelpContext, HelpFile, NativeError, Number, Source, and SQLState Properties Example (VB)
EOS and LineSeparator Properties and SkipLine Method Example (VB)
Execute, Requery, and Clear Methods Example (VB)
Filter and RecordCount Properties Example (VB)
Find Method Example (VB)
GetRows Method Example (VB)
GetString Method Example (VB)
IsolationLevel and Mode Properties Example (VB)
Item Property Example (VB)
MarshalOptions Property Example (VB)
MaxRecords Property Example (VB)
Move Method Example (VB)
MoveFirst, MoveLast, MoveNext, and MovePrevious Methods Example (VB)
NextRecordset Method Example (VB)
NumericScale and Precision Properties Example (VB)
Open and Close Methods Example (VB)
OpenSchema Method Example (VB)
Optimize Property Example (VB)
OriginalValue and UnderlyingValue Properties Example (VB)
Prepared Property Example (VB)
Provider and DefaultDatabase Properties Example (VB)
Read, ReadText, Write, and WriteText Methods Example (VB)
Refresh Method Example (VB)
Resync Method Example (VB)
Save and Open Methods Example (VB)
Seek Method and Index Property Example (VB)
Sort Property Example (VB)
Source Property Example (VB)
State Property Example (VB)
Status Property Example (Field) (VB)
Status Property Example (Recordset) (VB)
StayInSync Property Example (VB)
Supports Method Example (VB)
Type Property Example (Field) (VB)
Type Property Example (Property) (VB)
Update and CancelUpdate Methods Example (VB)
UpdateBatch and CancelBatch Methods Example (VB)
Value Property Example (VB)
Version Property Example (VB)
ADO Code Examples in Microsoft Visual Basic Scripting Edition
AddNew Method Example (VBScript)
Clone Method Example (VBScript)
Delete Method Example (VBScript)
Execute, Requery, and Clear Methods Example (VBScript)
Move Method Example (VBScript)
MoveFirst, MoveLast, MoveNext, and MovePrevious Methods Example (VBScript)
Open and Close Methods Example (VBScript)
ADO Code Examples in Microsoft Visual C++
ADO Events Model Example (VC++)
AbsolutePage, PageCount, and PageSize Properties Example (VC++)
AbsolutePosition and CursorLocation Properties Example (VC++)
ActiveCommand Property Example (VC++)
ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example (VC++)
ActualSize and DefinedSize Properties Example (VC++)
AddNew Method Example (VC++)
Append and CreateParameter Methods Example (VC++)
AppendChunk and GetChunk Methods Example (VC++)
Attributes and Name Properties Example (VC++)
BeginTrans, CommitTrans, and RollbackTrans Methods Example (VC++)
BOF, EOF, and Bookmark Properties Example (VC++)
CacheSize Property Example (VC++)
Cancel Method Example (VC++)
Clone Method Example (VC++)
CompareBookmarks Method Example (VC++)
ConnectionString, ConnectionTimeout, and State Properties Example (VC++)
Count Property Example (VC++)
CursorType, LockType, and EditMode Properties Example (VC++)
Delete Method Example (VC++)
Description, HelpContext, HelpFile, NativeError, Number, Source, and SQLState Properties Example (VC++)
Execute, Requery, and Clear Methods Example (VC++)
Filter and RecordCount Properties Example (VC++)
Find Method Example (VC++)
GetRows Method Example (VC++)
GetString Method Example (VC++)
IsolationLevel and Mode Properties Example (VC++)
Item Property Example (VC++)
MarshalOptions Property Example (VC++)
MaxRecords Property Example (VC++)
Move Method Example (VC++)
MoveFirst, MoveLast, MoveNext, and MovePrevious Methods Example (VC++)
NextRecordset Method Example (VC++)
NumericScale and Precision Properties Example (VC++)
Open and Close Methods Example (VC++)
OpenSchema Method Example (VC++)
Optimize Property Example (VC++)
OriginalValue and UnderlyingValue Properties Example (VC++)
Prepared Property Example (VC++)
Provider and DefaultDatabase Properties Example (VC++)
Refresh Method Example (VC++)
Resync Method Example (VC++)
Save and Open Methods Example (VC++)
Seek Method and Index Property Example (VC++)
Sort Property Example (VC++)
Source Property Example (VC++)
State Property Example (VC++)
Status Property Example (VC++)
StayInSync Property Example (VC++)
Supports Method Example (VC++)
Type Property Example (Field) (VC++)
Type Property Example (Property) (VC++)
Update and CancelUpdate Methods Example (VC++)
UpdateBatch and CancelBatch Methods Example (VC++)
Value Property Example (VC++)
Version Property Example (VC++)
ADO Code Examples in Microsoft Visual J++
AbsolutePage, PageCount, and PageSize Properties Example (VJ++)
AbsolutePosition and CursorLocation Properties Example (VJ++)
ActiveCommand Property Example (VJ++)
ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example (VJ++)
ActualSize and DefinedSize Properties Example (VJ++)
AddNew Method Example (VJ++)
Append and CreateParameter Methods Example (VJ++)
AppendChunk and GetChunk Methods Example (VJ++)
Attributes and Name Properties Example (VJ++)
BeginTrans, CommitTrans, and RollbackTrans Methods Example (VJ++)
BOF, EOF, and Bookmark Properties Example (VJ++)
CacheSize Property Example (VJ++)
Cancel Method Example (VJ++)
Clone Method Example (VJ++)
CompareBookmarks Method Example (VJ++)
ConnectionString, ConnectionTimeout, and State Properties Example (VJ++)
Count Property Example (VJ++)
CursorType, LockType, and EditMode Properties Example (VJ++)
Delete Method Example (VJ++)
Description, HelpContext, HelpFile, NativeError, Number, Source, and SQLState Properties Example (VJ++)
Execute, Requery, and Clear Methods Example (VJ++)
Filter and RecordCount Properties Example (VJ++)
Find Method Example (VJ++)
GetRows Method Example (VJ++)
GetString Method Example (VJ++)
IsolationLevel and Mode Properties Example (VJ++)
Item Property Example (VJ++)
MarshalOptions Property Example (VJ++)
MaxRecords Property Example (VJ++)
Move Method Example (VJ++)
MoveFirst, MoveLast, MoveNext, and MovePrevious Methods Example (VJ++)
NextRecordset Method Example (VJ++)
NumericScale and Precision Properties Example (VJ++)
Open and Close Methods Example (VJ++)
OpenSchema Method Example (VJ++)
Optimize Property Example (VJ++)
OriginalValue and UnderlyingValue Properties Example (VJ++)
Prepared Property Example (VJ++)
Provider and DefaultDatabase Properties Example (VJ++)
Refresh Method Example (VJ++)
Resync Method Example (VJ++)
Save and Open Methods Example (VJ++)
Sort Property Example (VJ++)
Source Property Example (VJ++)
State Property Example (VJ++)
Status Property Example (VJ++)
StayInSync Property Example (VJ++)
Supports Method Example (VJ++)
Type Property Example (Field) (VJ++)
Type Property Example (Property) (VJ++)
Update and CancelUpdate Methods Example (VJ++)
UpdateBatch and CancelBatch Methods Example (VJ++)
Value Property Example (VJ++)
Version Property Example (VJ++)
ADO Code Examples in Microsoft JScript
AbsolutePage, PageCount, and PageSize Properties Example (JScript)
AbsolutePosition and CursorLocation Properties Example (JScript)
ActiveCommand Property Example (JScript)
ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example (JScript)
ActualSize and DefinedSize Properties Example (JScript)
AddNew Method Example (JScript)
Append and CreateParameter Methods Example (JScript)
CacheSize Property Example (JScript)
Execute, Requery, and Clear Methods Example (JScript)
Filter and RecordCount Properties Example (JScript)
Find Method Example (JScript)
GetRows Method Example (JScript)
RDS API Reference
RDS Objects
DataControl Object (RDS)
Properties, Methods, and Events
DataFactory Object (RDSServer)
Properties, Methods, and Events
DataSpace Object (RDS)
Properties, Methods, and Events
RDS Properties
Connect Property (RDS)
ExecuteOptions Property (RDS)
FetchOptions Property (RDS)
FilterColumn Property (RDS)
FilterCriterion Property (RDS)
FilterValue Property (RDS)
Handler Property (RDS)
InternetTimeout Property (RDS)
ReadyState Property (RDS)
Recordset, SourceRecordset Properties (RDS)
Server Property (RDS)
SortColumn Property (RDS)
SortDirection Property (RDS)
SQL Property (RDS)
URL Property (RDS)
RDS Methods
Cancel Method (RDS)
CancelUpdate Method (RDS)
ConvertToString Method (RDS)
CreateObject Method (RDS)
CreateRecordset Method (RDS)
MoveFirst, MoveLast, MoveNext, and MovePrevious Methods (RDS)
Query Method (RDS)
Refresh Method (RDS)
Reset Method (RDS)
SubmitChanges Method (RDS)
RDS Events
onError Event (RDS)
onReadyStateChange Event (RDS)
RDS Code Examples
RDS Code Examples in Microsoft Visual Basic
Handler Property Example (VB)
InternetTimeout Property Example (VB)
RDS Code Examples in Microsoft Visual Basic Scripting Edition
Cancel Method Example (VBScript)
CancelUpdate Method Example (VBScript)
Connect Property Example (VBScript)
ConvertToString Method Example (VBScript)
CreateRecordset Method Example (VBScript)
DataControl Object Example (VBScript)
DataSpace Object and CreateObject Method Example (VBScript)
DataFactory Object, Query Method, and CreateObject Method Example (VBScript)
ExecuteOptions and FetchOptions Properties Example (VBScript)
FilterColumn, FilterCriterion, FilterValue, SortColumn, and SortDirection Properties and Reset Method Example (VBScript)
ReadyState Property Example (VBScript)
Recordset and SourceRecordset Properties Example (VBScript)
Refresh Method Example (VBScript)
Server Property Example (VBScript)
SQL Property Example (VBScript)
SubmitChanges Method Example (VBScript)
URL Property Example (VBScript)
RDS Code Examples in Microsoft Visual C++
Handler Property Example (VC++)
InternetTimeout Property Example (VC++)
RDS Code Examples in Microsoft Visual J++
Handler Property Example (VJ++)
InternetTimeout Property Example (VJ++)
ADO MD API Reference
ADO MD Object Model
ADO MD Objects
Axis Object (ADO MD)
Properties, Methods, and Events
Catalog Object (ADO MD)
Properties, Methods, and Events
Cell Object (ADO MD)
Properties, Methods, and Events
Cellset Object (ADO MD)
Properties, Methods, and Events
CubeDef Object (ADO MD)
Properties, Methods, and Events
Dimension Object (ADO MD)
Properties, Methods, and Events
Hierarchy Object (ADO MD)
Properties, Methods, and Events
Level Object (ADO MD)
Properties, Methods, and Events
Member Object (ADO MD)
Properties, Methods, and Events
Position Object (ADO MD)
Properties, Methods, and Events
ADO MD Collections
Axes Collection (ADO MD)
Axes Collection Properties, Methods, and Events
CubeDefs Collection (ADO MD)
CubeDefs Collection Properties, Methods, and Events
Dimensions Collection (ADO MD)
Dimensions Collection Properties, Methods, and Events
Hierarchies Collection (ADO MD)
Hierarchies Collection Properties, Methods, and Events
Levels Collection (ADO MD)
Levels Collection Properties, Methods, and Events
Members Collection (ADO MD)
Members Collection Properties, Methods, and Events
Positions Collection (ADO MD)
Positions Collection Properties, Methods, and Events
ADO MD Properties
ActiveConnection Property (ADO MD)
Caption Property (ADO MD)
ChildCount Property (ADO MD)
Children Property (ADO MD)
Depth Property (ADO MD)
Description Property (ADO MD)
DimensionCount Property (ADO MD)
DrilledDown Property (ADO MD)
FilterAxis Property (ADO MD)
FormattedValue Property (ADO MD)
Item Property (ADO MD Cellset)
LevelDepth Property (ADO MD)
LevelName Property (ADO MD)
Name Property (ADO MD)
Ordinal Property (ADO MD Cell)
Ordinal Property (ADO MD Position)
Parent Property (ADO MD)
ParentSameAsPrev Property (ADO MD)
Source Property (ADO MD)
State Property (ADO MD)
Type Property (ADO MD)
UniqueName Property (ADO MD)
Value Property (ADO MD)
ADO MD Methods
Close Method (ADO MD)
GetSchemaObject Method
Open Method (ADO MD)
ADO MD Enumerated Constants
SchemaObjectTypeEnum
MemberTypeEnum
ADO MD Code Examples
ADO MD Code Examples in Visual Basic
Cellset Example (VB)
Catalog Example (VB)
ADO MD Code Examples in Visual Basic, Scripting Edition
Axis Example (VBScript)
Members Example (VBScript)
CubeDef Example (VBScript)
ADOX API Reference
ADOX Object Model
ADOX Objects
Catalog Object (ADOX)
Properties, Methods, and Events
Column Object (ADOX)
Properties, Methods, and Events
Group Object (ADOX)
Properties, Methods, and Events