• • Welcome to ADO
    
  • • ADO Overview
      
    • • Shorthand for Creating a Recordset
        
      • Recordset Persistence
        
      • Index Support and Find, Sort, and Filter
        
      • ADO for Windows Foundation Classes
        
      • • ADO Event Model and Asynchronous Operations
          
        • ADO Event Summary
          
        • ADO Events
          
        • Types of Events
          
        • Event Parameters
          
        • How Event Handlers Work Together
          
        • ADO Events in ADO/WFC
          
        • ADO Event Instantiation by Language
          
      • • VC++ Extensions for ADO
          
        • ADO VC++ Extensions Summary
          
        • ADO VC++ Extensions
          
        • Using ADO VC++ Extensions
          
        • VC++ Extensions Header in Detail
          
        • Example: ADO Without Extensions
          
        • Example: ADO with Extensions
          
      • • Hierarchical Cursors and Data Shaping
          
        • Hierarchical Cursors and Data Shaping
          
        • Required Providers for Data Shaping
          
        • Shape Commands in General
          
        • Shape Append Command
          
        • Shape Compute Command
          
        • Accessing Rows in an Hierarchical Recordset
          
        • Formal Shape Grammar
          
      • • DataFactory Customization
          
        • DataFactory Customization Summary
          
        • Customizing the RDSServer.DataFactory Object
          
        • 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
          
    • • Getting Started with ADO 2.0
        
      • • Solutions for Local Data Access
          
        • Basic ADO Programming Model
          
        • ADO Programming Model in Detail
          
        • ADO Programming Model with Objects
          
        • ADO Object Model Summary
          
      • • Solutions for Remote Data Access
          
        • Basic RDS Programming Model
          
        • RDS Programming Model in Detail
          
        • RDS Programming Model with Objects
          
        • RDS Object Model Summary
          
    • • ADO Object Model
        
      • • Command Object
          
        • Connection Object
          
        • Error Object
          
        • Field Object
          
        • Parameter Object
          
        • Property Object
          
        • RDS.DataControl Object
          
        • RDS.DataSpace Object
          
        • RDSServer.DataFactory Object
          
        • Recordset Object
          
      • • Errors Collection
          
        • Fields Collection
          
        • Parameters Collection
          
        • Properties Collection
          
      • • • AddNew
            
          • Append
            
          • AppendChunk
            
          • BeginTrans, CommitTrans, RollbackTrans
            
          • Cancel
            
          • Cancel (RDS)
            
          • CancelBatch
            
          • CancelUpdate
            
          • CancelUpdate (RDS)
            
          • Clear
            
          • Clone
            
          • Close
            
          • CompareBookmarks
            
          • ConvertToString
            
          • CreateObject
            
          • CreateParameter
            
          • CreateRecordset
            
        • • Delete (Fields Collection)
            
          • Delete (Parameters Collection)
            
          • Delete (Recordset)
            
          • Execute (Command)
            
          • Execute (Connection)
            
          • Find
            
          • GetChunk
            
          • GetRows
            
          • GetString (Recordset)
            
          • Item
            
          • Move
            
          • MoveFirst, MoveLast, MoveNext, MovePrevious (ADO)
            
          • MoveFirst, MoveLast, MoveNext, MovePrevious (RDS)
            
          • NextRecordset
            
        • • Open (Connection)
            
          • Open (Recordset)
            
          • OpenSchema
            
          • Query
            
          • Refresh (ADO)
            
          • Refresh (RDS)
            
          • Requery
            
          • Reset
            
          • Resync
            
          • Save (Recordset)
            
          • SubmitChanges
            
          • Supports
            
          • Update
            
          • UpdateBatch
            
      • • BeginTransComplete, CommitTransComplete, and RollbackTransComplete
          
        • ConnectComplete and Disconnect
          
        • EndOfRecordset
          
        • ExecuteComplete
          
        • FetchComplete
          
        • FetchProgress
          
        • InfoMessage
          
        • onError
          
        • onReadyStateChange
          
        • WillChangeField and FieldChangeComplete
          
        • WillChangeRecord and RecordChangeComplete
          
        • WillChangeRecordset and RecordsetChangeComplete
          
        • WillConnect
          
        • WillExecute
          
        • WillMove and MoveComplete
          
      • • • AbsolutePage
            
          • AbsolutePosition
            
          • ActiveCommand
            
          • ActiveConnection
            
          • ActualSize
            
          • Attributes
            
          • BOF and EOF
            
          • Bookmark
            
        • • CacheSize
            
          • CommandText
            
          • CommandTimeout
            
          • CommandType
            
          • Connect
            
          • ConnectionString
            
          • ConnectionTimeout
            
          • Count
            
          • CursorLocation
            
          • CursorType
            
        • • DataMember
            
          • DataSource
            
          • DefaultDatabase
            
          • DefinedSize
            
          • Description
            
          • Direction
            
          • EditMode
            
          • ExecuteOptions
            
          • FetchOptions
            
          • Filter
            
          • FilterColumn
            
          • FilterCriterion
            
          • FilterValue
            
          • Handler
            
          • InternetTimeout
            
          • IsolationLevel
            
        • • LockType
            
          • MarshalOptions
            
          • MaxRecords
            
          • Mode
            
          • Name
            
          • NativeError
            
          • Number
            
          • NumericScale
            
        • • Optimize
            
          • OriginalValue
            
          • PageCount
            
          • PageSize
            
          • Precision
            
          • Prepared
            
          • Provider
            
          • ReadyState
            
          • RecordCount
            
          • Recordset and SourceRecordset
            
        • • Server
            
          • Size
            
          • Sort
            
          • SortColumn
            
          • SortDirection
            
          • Source (Error)
            
          • Source (Recordset)
            
          • SQL
            
          • SQLState
            
          • State
            
          • Status
            
          • StayInSync
            
          • Type
            
          • UnderlyingValue
            
          • URL
            
          • Value
            
          • Version
            
    • • Using OLE DB Providers with ADO and RDS
        
      • Microsoft OLE DB Provider for ODBC
        
      • Microsoft OLE DB Provider for Microsoft Index Server
        
      • Microsoft OLE DB Provider for Microsoft Active Directory Service
        
      • Microsoft OLE DB Provider for the Microsoft Jet Database Engine
        
      • Microsoft SQL Server OLE DB Provider
        
      • Microsoft OLE DB Provider for Oracle
        
    • • • • ADO Tutorial
            
          • Step 1: Open a Connection
            
          • Step 2: Create a Command
            
          • Step 3: Execute the Command
            
          • Step 4: Manipulate the data
            
          • Step 5: Update the data
            
          • Step 6: Conclude the Update
            
          • ADO Tutorial (VB)
            
          • ADO Tutorial (VC++)
            
          • ADO Tutorial (VJ++)
            
        • • RDS Tutorials
            
          • • RDS Tutorial
              
            • Step 1: Specify a Server Program
              
            • Step 2: Invoke the Server Program
              
            • Step 3: Server Obtains a Recordset
              
            • Step 4: Server Returns the Recordset
              
            • Step 5: DataControl is made usable
              
            • Step 6: Changes are Sent to the Server
              
            • RDS Tutorial (VBScript)
              
            • RDS Tutorial (VJ++)
              
          • • Tutorial: Building a Simple Remote Data Service Application
              
            • Identify the Database
              
            • Insert the Grid and RDS.DataControl Object
              
            • Add HTML Controls
              
            • Add Code to Send a Query to the Database
              
            • Add Code to Submit Changes to the Database
              
            • Add Code to Move through the Displayed Recordset
              
            • See the Code in Action
              
          • • Tutorial: Address Book
              
            • Running the Address Book Sample Application
              
            • System Requirements for the Address Book Application
              
            • Setting Up an ODBC Connection for Address Book
              
            • Running the Address Book SQL Script
              
            • • Address Book Sample Application Code Overview
                
              • HTML Framework for Address Book
                
              • Address Book Text Boxes
                
              • Address Book Command Buttons
                
              • Address Book Data-Binding Object
                
              • Address Book Data Grid
                
              • Address Book Navigation Buttons
                
              • VBScript Initialization Code
                
              • Address Book Application Source Code
                
      • • Sample and Demo Applications for Remote Data Service
          
      • • Remote Data Service Developer's Guide
          
        • • Understanding Remote Data Service Applications
            
          • Three-Tiered Applications
            
          • How a Remote Data Service Application Works
            
          • Related Technologies
            
        • • Developing Remote Data Service Applications
            
          • Getting a Recordset to the Client
            
          • Getting a Recordset with the RDS.DataControl Object
            
          • Getting a Recordset with the RDSServer.DataFactory Object
            
          • Getting a Recordset with a Custom Business Object
            
          • Writing Code to Pass Recordset Objects with a Custom ActiveX DLL
            
          • Passing Updated Recordset Objects to the Middle Tier
            
          • Using RDS.DataControl to Pass Updated Disconnected Recordset Objects Back to the Middle Tier
            
          • Using ADO to Pass Recordset Objects to the Middle Tier
            
          • Defining a Recordset
            
        • • Troubleshooting Remote Data Service
            
          • "Internet Server Error: Access Denied"
            
          • "Unexpected Error" Message When Running the Sample Applications
            
          • Using the RDS.DataControl with the Sheridan Combo Box Control
            
          • Deadlocks With Read Repeatable Isolation Level
            
          • RDS.DataControl and Multiple Recordset Requests
            
          • Outdated Class IDs
            
      • • • AbsolutePage, PageCount, and PageSize Properties Example
            
          • AbsolutePosition and CursorLocation Properties Example
            
          • ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example
            
          • ActualSize and DefinedSize Properties Example
            
          • AddNew Method Example
            
          • Append and CreateParameter Methods Example
            
          • AppendChunk and GetChunk Methods Example
            
          • Attributes and Name Properties Example
            
          • BeginTrans, CommitTrans, and RollbackTrans Methods Example
            
          • BOF, EOF, and Bookmark Properties Example
            
        • • CacheSize Property Example
            
          • Cancel Method Example
            
          • Cancel Method Example (VBScript)
            
          • CancelUpdate Method Example (VBScript)
            
          • Clone Method Example
            
          • Connect Property Example
            
          • ConnectionString, ConnectionTimeout, and State Properties Example
            
          • ConvertToString Method Example
            
          • Count Property Example
            
          • CreateRecordset Method Example
            
          • CursorType, LockType, and EditMode Properties Example
            
          • Delete Method Example
            
          • Description, NativeError, Number, Source, and SQLState Properties Example
            
        • • Execute, Requery, and Clear Methods Example
            
          • ExecuteOptions and FetchOptions Properties Example
            
          • Filter and RecordCount Properties Example
            
          • FilterColumn, FilterCriterion, FilterValue, SortColumn, and SortDirection Properties and Reset Method Example
            
          • GetRows Method Example
            
          • IsolationLevel and Mode Properties Example
            
          • MarshalOptions Property Example
            
          • MaxRecords Property Example
            
          • Move Method Example
            
          • MoveFirst, MoveLast, MoveNext, and MovePrevious Methods Example
            
        • • NextRecordset Method Example
            
          • NumericScale and Precision Properties Example
            
          • Open and Close Methods Example
            
          • OpenSchema Method Example
            
          • OriginalValue and UnderlyingValue Properties Example
            
          • Prepared Property Example
            
          • Provider and DefaultDatabase Properties Example
            
          • RDS.DataControl Object Example (VBScript)
            
          • RDS.DataSpace Object and CreateObject Method Example (VBScript)
            
          • RDSServer.DataFactory Object, Query Method, and CreateObject Method Example (VBScript)
            
          • ReadyState Property Example
            
          • Recordset and SourceRecordset Properties Example
            
          • Refresh Method Example
            
          • Refresh Method Example (VBScript)
            
          • Resync Method Example
            
        • • Server Property Example
            
          • Source Property Example
            
          • SQL Property Example
            
          • State Property Example
            
          • Status Property
            
          • SubmitChanges Method Example
            
          • Supports Method Example
            
          • Type Property Example
            
          • Update and CancelUpdate Methods Example
            
          • UpdateBatch and CancelBatch Methods Example
            
          • Value Property Example
            
          • Version Property Example
            
    • • Syntax Index (ADO/WFC)
        
      • Syntax Index (VC++)
        
    • • ADO Error Codes
        
      • RDS.DataControl Error Codes
        
      • Internet Explorer Error Codes
        
      • Internet Information Server Error Codes
        
    • • Granting Guest Privileges to a Web Server Computer
        
      • Required Custom Business Object Registry Entry
        
      • Marking Business Objects as Safe for Scripting
        
      • Client-side Registry Entries for Business Objects with DCOM
        
      • Enabling a DLL to Run on DCOM
        
    • • ADO Glossary
        
  • • ADO MD Overview
      
    • • Programming with ADO MD
        
      • Using ADO with ADO MD
        
      • Overview of Multidimensional Schemas and Data
        
      • Working with Multidimensional Data
        
    • • ADO MD Object Model
        
      • Axis Object (ADO MD)
        
      • Catalog Object (ADO MD)
        
      • Cell Object (ADO MD)
        
      • Cellset Object (ADO MD)
        
      • CubeDef Object (ADO MD)
        
      • Dimension Object (ADO MD)
        
      • Hierarchy Object (ADO MD)
        
      • Level Object (ADO MD)
        
      • Member Object (ADO MD)
        
      • Position Object (ADO MD)
        
    • • Axes Collection (ADO MD)
        
      • CubeDefs Collection (ADO MD)
        
      • Dimensions Collection (ADO MD)
        
      • Hierarchies Collection (ADO MD)
        
      • Levels Collection (ADO MD)
        
      • Members Collection (ADO MD)
        
      • Positions Collection (ADO MD)
        
    • • Close Method (ADO MD)
        
      • Item Method (ADO MD Cellset)
        
      • Item Method (ADO MD Collection)
        
      • Open Method (ADO MD)
        
      • Refresh Method (ADO MD)
        
    • • ActiveConnection Property (ADO MD)
        
      • Caption Property (ADO MD)
        
      • ChildCount Property (ADO MD)
        
      • Children Property (ADO MD)
        
      • Count 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)
        
      • 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)
        
    • • Cellset Example (ADO MD)
        
      • CubeDef Example (ADO MD)
        
      • Cell Example (ADO MD)
        
      • Connection Example (ADO MD)