Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
ISBN: 0735605904
EAN: 2147483647
EAN: 2147483647
Year: 1998
Pages: 1083
Pages: 1083
Authors: Microsoft Corporation
- Cover
- Part 1 Introduction to OLE DB
- Chapter 1: Overview of OLE DB
- Conceptual Programming Models in OLE DB
- Rowset Programming and Object Model
- Enumerator Objects
- Data Source Objects
- Session Objects
- Transaction Management
- Command Objects
- Rowset Objects
- Special-Purpose Rowsets
- Row and Stream Objects
- Error Objects
- Binder Programming and Object Model
- Root Binder Objects
- Provider Binder Objects
- Row Objects
- Stream Objects
- Component Database Management Systems
- Chapter 2: Data Source and Session Objects
- Data Source Objects
- Creating Data Source Objects
- Data Source Object States
- Data Source Object Example
- Enumerators
- Enumerating Data Source Objects and Enumerators
- Enumerator States
- Enumerator Example
- Session Objects
- Session Object Example
- Chapter 3: Commands
- Using Commands
- Command States
- Command Object Example
- Multiple Results
- Using Parameters
- Rowset Properties in Command Objects
- Chapter 4: Rowsets
- Creating Rowsets
- Creating a Rowset with IOpenRowset
- Creating a Rowset with a Command
- Rowset Creation Example
- Rows and Row Handles
- Fetching Rows
- Reference Counting of Row Handles
- Next Fetch Position
- Fetch Direction
- Uniqueness of Rows in the Rowset
- Deferred Columns
- Column IDs
- Bookmarks
- Bookmark Types
- Comparing Bookmarks
- Standard Bookmarks
- Invalid Bookmarks
- Views
- Chapters
- Hierarchical Rowsets
- One Rowset for Each Hierarchy Level
- Navigating Hierarchical Rowsets
- Chapter Columns
- Chapters and Detail Groupings
- Lifetime of Row Handles Within Chapters
- Releasing Rowsets
- Chapter 5: Updating Data in Rowsets
- Changing Data
- Immediate vs. Deferred Update Mode
- Row States in Deferred Update Mode
- Visibility of Changes
- Visibility of Pending Changes
- Visibility of Transmitted Changes
- Position of Inserted Rows
- Visibility of Other Changes
- Refreshing Row Data
- Chapter 6: Getting and Setting Data
- Binding Data Values
- Value
- Length
- Status
- Accessors
- Using Accessors
- Optimized Accessors
- Reference Accessors
- Bindings
- DBBINDING Structures
- Binding and Accessor Example
- Responsibility for Freeing Memory
- Data Transfer Procedures
- Getting Data
- Setting Data
- Chapter 7: BLOBs and COM Objects
- Accessing BLOB Data
- BLOBs as In-Memory Data
- BLOBs as Storage Objects
- Limitations of Storage Objects
- Lifetime of Storage Objects
- Getting and Setting BLOB Data with Storage Objects
- Storage Objects and Rowset Update Semantics
- Storage Objects and Transactions
- IPersist Objects
- Getting and Setting IPersist Objects
- Lifetime of IPersist Objects
- IPersist Objects, Rowset Update Semantics, and ITransaction
- Chapter 8: Binder Objects and Direct Binding
- Binder Objects
- Root Binder Object
- Provider Binder Objects
- Direct Binding
- Provider and Consumer Support for Direct Binding
- Inheritance of Bind Options
- Chapter 9: Row and Stream Objects
- Row Objects
- Creating Row Objects
- Row Metadata
- Special Row Column DBIDs
- Column Values
- Transactions on Row Objects
- Provider and Consumer Support for Row Objects
- Stream Objects
- Modeling Tree-Structured Namespaces
- Direct Binding in Tree-Structured Namespaces
- Navigating Tree-Structured Namespaces
- Scoped Tree Manipulation Operations
- Resource Rowsets and Document Source Providers
- Chapter 10: Index Rowsets
- Structure of Index Rowsets
- Using Index Rowsets
- Index Example
- Chapter 11: Integrated Indexes
- Requesting Integrated Indexes
- Using Integrated Indexes
- Structure of Integrated Indexes
- Fetching Rows
- Rowset Order
- Next Fetch Position
- Range
- Updating Index Rows
- Visibility of Changes in the Index
- Effect of Changes on the Next Fetch Position
- Effect of Changes on the Index Range
- Accessors
- Integrated Indexes and Commands
- Integrated Index Example
- Chapter 12: OLE DB Object Notifications
- When Notifications Are Sent
- States and State Transitions in Providers
- States and State Transitions in Consumers
- Chapter 13: Data Types in OLE DB
- Using Type Indicators in Providers
- Type Indicators in an ANSI SQL Provider
- Type Indicators in a Microsoft Access Provider
- Type Indicators in a Microsoft SQL Server Provider
- Using Type Indicators in Consumers
- Using Type Indicators When Creating Tables
- Using Type Indicators When Getting and Setting Data
- String Data
- Fixed-Length and Variable-Length Data Types
- Data Type Conversion
- Chapter 14: Properties
- Property Sets and Property Groups
- Setting Property Values
- Getting Property Values
- Getting Information About Properties
- Property Structures and Enumerated Types
- DBPROP Structure
- DBPROPFLAGS Enumerated Type
- DBPROPID Type
- DBPROPIDSET Structure
- DBPROPINFO Structure
- DBPROPINFOSET Structure
- DBPROPOPTIONS Enumerated Type
- DBPROPSET Structure
- DBPROPSTATUS Enumerated Type
- Property Example
- Chapter 15: Transactions
- Simple Transactions
- Committing and Aborting Simple Transactions
- Transaction Retention
- Rowset Preservation
- Nested Transactions
- ITransactionObject
- Distributed Transactions
- Isolation Levels in OLE DB
- Transaction Locks
- Event Notifications
- Chapter 16: Errors
- Return Codes
- Arrays of Errors
- Automation Error Objects
- How an Automation Component Returns an Error Object
- How an Automation Consumer Retrieves an Error Object
- OLE DB Error Objects
- Error Object Example
- Error Records
- ERRORINFO Structure
- Error Parameters
- Custom Error Objects
- Dynamic Error ID
- Lookup ID
- Error Record Example
- Interfaces Used by OLE DB Error Objects
- How a Provider Returns an OLE DB Error Object
- How a Consumer Retrieves an OLE DB Error Object
- OLE DB Error Objects and Threads
- Error Lookup Services
- Chapter 17: Asynchronous Processing
- Asynchronous Data Source Initialization
- Asynchronous Command Execution and Rowset Generation
- Asynchronous Rowset Population
- Asynchronous URL Binding
- Asynchronous Scoped Operations
- Chapter 18: Programming Considerations
- Aggregation
- Registry Entries
- Enumerator Registry Entries
- Provider Registry Entries
- Error Lookup Service Registry Entries
- Binder Registry Entries
- Provider Threading Models
- Single-Threaded Providers and Consumers
- Provider Threading Responsibilities
- Consumer Threading Responsibilities
- Threading and Notifications
- Threading and Error Objects
- Threading and Transactions
- Threading and COM Objects
- Argument Memory
- Argument Validation
- Part 2 OLE DB Core
- Chapter 19: OLE DB Services
- Resource Pooling
- Writing Scalable OLE DB Providers
- How Providers Work Effectively with Resource Pooling
- How Consumers Use Resource Pooling
- Automatic Transaction Enlistment
- Enabling and Disabling Individual OLE DB Services
- Setting Provider Service Defaults
- Overriding Provider Service Defaults
- Chapter 20: OLE DB Core Components
- Root Enumerator Object
- Row Position Object
- Connection Strings and Data Links
- Connection String Syntax
- OLE DB Initialization Properties: Quick Reference
- Data Link API Overview
- Referencing a Connection String in Your Application
- Provider Extensible Data Link User Interface API
- Implementing Customized User Interfaces in OLE DB Providers
- Interfaces Implemented by the Provider
- Interfaces Implemented by the Data Link Core Component
- Flow of Operations
- Localization
- Help and Documentation
- Part 3 OLE DB for Online Analytical Processing (OLAP)
- Chapter 21: OLE DB for OLAP Overview
- Introduction to OLE DB for OLAP
- SalesData Example
- Chapter 22: OLE DB for OLAP Concepts
- Multidimensional Schemas
- Browsing Metadata
- Caching Schema Rowset Information
- Virtual Cubes
- Hypercubes and Multicubes
- Browsing Members
- Named and Unnamed Levels
- Supported Hierarchy Types
- Datasets and Multidimensional Expressions
- Multidimensional Expressions Overview
- Implementation Strategies for Providers
- Delimited Identifiers
- Delimited Identifiers Returned from the Provider
- Differences in Delimit Characters
- Datasets
- Describing the Axes
- Finding and Returning Slicer Information
- Navigating Cells in a Dataset
- Describing and Fetching Cell Data
- Stateless Navigation
- Creating Multiple Datasets
- Getting the Command Object from a Dataset
- Chapter 23: OLE DB for OLAP Objects and Schema Rowsets
- Enumerator Object
- Registry Entries
- Data Source Object
- Keywords
- Session Object
- Multidimensional Schema Object Names
- Additions to IDBSchemaRowset
- Object Names in Schema Rowsets
- Sizes of UNIQUE_NAME Columns
- Using Schema Rowsets in OLE DB for OLAP
- ACTIONS Rowset
- Using the ACTIONS Rowset
- Querying for Actions
- Types of Predefined Actions
- COORDINATE Column Format in the ACTIONS Rowset
- CUBES Rowset
- DIMENSIONS Rowset
- FUNCTIONS Rowset
- HIERARCHIES Rowset
- LEVELS Rowset
- MEASURES Rowset
- PROPERTIES Rowset
- MEMBERS Rowset
- Restrictions in the MEMBERS Rowset
- Same Member in Multiple Hierarchies
- Complex Member Relationships
- SETS Rowset
- The ANNOTATIONS Column
- Command Object
- Semantics of DBGUID_DEFAULT
- Controlling the Creation of Instances of a Rowset or a Dataset
- Dataset Object
- IMDDataset Interface
- MDAXISINFO Structure
- Axis Rowsets
- Effect of DIMENSION PROPERTIES Clause on Axis Rowset
- Axis Rowsets and Calculated Members
- Mandatory Member Properties
- Chapter 24: Rowsets in OLE DB for OLAP
- Range Rowsets
- Flattening a Dataset to Produce a Rowset
- Flattening Algorithm
- Using Measures on the COLUMNS Axis
- Complex Flattened Rowset Example
- DIMENSION PROPERTIES Example
- Order of Members in a Flattened Rowset
- Getting a Flattened Rowset
- Appearance of NULLs in a Flattened Rowset
- Support Level for Named Levels
- Working with Cell Data
- Creating an Accessor to Fetch Data
- Data Source Property MDPROP_RANGEROWSET
- Deleting Cells
- Cell Insertion Prohibited
- Update Dependencies
- Visibility of Changes
- Chapter 25: Multidimensional Expressions
- MDX Concepts
- Parts of an MDX Statement
- Leveling Rules for MDX Statements
- Axis and Slicer Dimensions
- Establishing Cube Context
- Specifying the Contents of an Axis
- Set, Tuple, and Member Specification
- Projecting Tuple Sets on Axes
- The SELECT List
- Specifying Slicer Dimensions
- SalesData Example Dataset Expression
- Namespace and Unique Names
- Provider Implementation Considerations for Unique Names
- Using the OLE DB Command Object
- Advanced MDX
- The MDX Statement
- Retrieving Member Properties
- Retrieving Cell Properties
- Contents of FORMAT_STRING
- Contents of FORE_COLOR and BACK_COLOR
- Join Compatibility
- Empty FROM Clause
- Default Hierarchy and Member
- Types of Expressions in MDX
- Set Value Expressions
- Member Value Expressions
- Tuple Value Expressions
- Numeric Functions
- Time Series Functions
- Time Series Analysis (Numeric) Functions
- String Manipulation Functions
- Comparing CROSSJOIN and ORDER: A Provider Implementation Note
- WHERE Clause Overrides
- Creating a Cell Within the Context of a Cube
- Querying on Property Values
- Using Outer References in a Query
- Named Sets and Calculated Members
- Defining a New Member Example
- Defining and Qualifying a New Member Example
- Assigning a Solve Order Example
- Longer Lifetime and Scope: Named Sets and Calculated Members
- Visibility in Schema Rowsets
- Set Functions for Expressing User-Interface Operations
- Drilling by Member
- Drilling by Level
- Drilling Through
- Preserving State During User-Interface Operations
- Conditional Expressions
- IF Clause
- Simple Case Expression
- Searched Case Expression
- Empty Cells
- Semantics of Empty Cell Value
- COALESCEEMPTY Function
- Counting Empty Cells
- Empty Cells in a Dataset
- Dimension Write-Back
- User-Defined Functions
- Chapter 26: MDX Grammar
- MDX Elements
- Leveling Rules for MDX Elements
- MDX Statements
- General Leveling Rules for MDX Statements
- MDX Statement Definitions
- MDX Set Value Expressions
- Leveling Rules for MDX Set Value Expressions
- MDX Member Value Expressions
- Leveling Rules for Member Value Expressions
- MDX Tuple Value Expressions
- MDX Conditional Expressions
- MDX Numeric Value Functions
- Leveling Rules for MDX Numeric Value Functions
- MDX Search Condition
- Leveling Rules for MDX Search Condition
- MDX Statement Construction
- Leveling Rules for MDX Statement
- Chapter 27: Mapping MDX to SQL Statements
- Concept of Mapping Sets
- Tables and Sets
- Literal Sets
- Mapping Overview
- FROM Clause
- Axis Expressions
- WHERE Clause
- Sample Cube
- MEMBERS Table
- LEVELS Table
- FACT Table
- Converting a Set Expression into a Table
- UNION Function
- EXCEPT Function
- INTERSECT Function
- CROSSJOIN Function
- HIERARCHIZE Function
- Simple Extensions to SQL-92
- Local Temporary Views
- Special Value: ALL()
- Rank Operations
- New Functions Extending SQL-92
- Mapping Example
- COLUMNS Axis Expression
- ROWS Axis Expression
- Getting Cell Values
- Chapter 28: OLE DB for OLAP Code Samples
- Connecting to an MDP by Using the Root Enumerator
- Creating an Instance of a Data Source Object Directly by Using the Provider s CLSID
- Creating a Schema Rowset
- Creating a Dataset and Obtaining Axis Information
- Creating a Dataset and Getting Cell Data
- Part 4 OLE DB Reference
- OLE DB Interfaces
- IAccessor
- IAccessor::AddRefAccessor
- IAccessor::CreateAccessor
- IAccessor::GetBindings
- IAccessor::ReleaseAccessor
- IAlterIndex
- IAlterIndex::AlterIndex
- IAlterTable
- IAlterTable::AlterColumn
- IAlterTable::AlterTable
- IBindResource
- IBindResource::Bind
- IChapteredRowset
- IChapteredRowset::AddRefChapter
- IChapteredRowset::ReleaseChapter
- IColumnsInfo
- IColumnsInfo::GetColumnInfo
- IColumnsInfo::MapColumnIDs
- IColumnsInfo2 : IColumnsInfo
- IColumnsInfo2::GetRestrictedColumnInfo
- IColumnsRowset
- IColumnsRowset::GetAvailableColumns
- IColumnsRowset::GetColumnsRowset
- ICommand
- ICommand::Cancel
- ICommand::Execute
- ICommand::GetDBSession
- ICommandPersist
- ICommandPersist::DeleteCommand
- ICommandPersist::GetCurrentCommand
- ICommandPersist::LoadCommand
- ICommandPersist::SaveCommand
- ICommandPrepare
- ICommandPrepare::Prepare
- ICommandPrepare::Unprepare
- ICommandProperties
- ICommandProperties::GetProperties
- ICommandProperties::SetProperties
- ICommandStream
- ICommandStream::GetCommandStream
- ICommandStream::SetCommandStream
- ICommandText : ICommand
- ICommandText::GetCommandText
- ICommandText::SetCommandText
- ICommandWithParameters
- ICommandWithParameters:: GetParameterInfo
- ICommandWithParameters:: MapParameterNames
- ICommandWithParameters:: SetParameterInfo
- IConvertType
- IConvertType::CanConvert
- ICreateRow
- ICreateRow::CreateRow
- IDBAsynchNotify
- IDBAsynchNotify::OnLowResource
- IDBAsynchNotify::OnProgress
- IDBAsynchNotify::OnStop
- IDBAsynchStatus
- IDBAsynchStatus::Abort
- IDBAsynchStatus::GetStatus
- IDBBinderProperties : IDBProperties
- IDBBinderProperties::Reset
- IDBCreateCommand
- IDBCreateCommand::CreateCommand
- IDBCreateSession
- IDBCreateSession::CreateSession
- IDBDataSourceAdmin
- IDBDataSourceAdmin::CreateDataSource
- IDBDataSourceAdmin::DestroyDataSource
- IDBDataSourceAdmin::GetCreationProperties
- IDBDataSourceAdmin::ModifyDataSource
- IDBInfo
- IDBInfo::GetKeywords
- IDBInfo::GetLiteralInfo
- IDBInitialize
- IDBInitialize::Initialize
- IDBInitialize::Uninitialize
- IDBProperties
- IDBProperties::GetProperties
- IDBProperties::GetPropertyInfo
- IDBProperties::SetProperties
- IDBSchemaRowset
- IDBSchemaRowset::GetRowset
- IDBSchemaRowset::GetSchemas
- IErrorInfo
- IErrorInfo::GetDescription
- IErrorInfo::GetGUID
- IErrorInfo::GetHelpContext
- IErrorInfo::GetHelpFile
- IErrorInfo::GetSource
- IErrorLookup
- IErrorLookup::GetErrorDescription
- IErrorLookup::GetHelpInfo
- IErrorLookup::ReleaseErrors
- IErrorRecords
- IErrorRecords::AddErrorRecord
- IErrorRecords::GetBasicErrorInfo
- IErrorRecords::GetCustomErrorObject
- IErrorRecords::GetErrorInfo
- IErrorRecords::GetErrorParameters
- IErrorRecords::GetRecordCount
- IGetDataSource
- IGetDataSource::GetDataSource
- IGetRow
- IGetRow::GetRowFromHROW
- IGetRow::GetURLFromHROW
- IGetSession
- IGetSession::GetSession
- IGetSourceRow
- IGetSourceRow::GetSourceRow
- IIndexDefinition
- IIndexDefinition::CreateIndex
- IIndexDefinition::DropIndex
- IMultipleResults
- IMultipleResults::GetResult
- IOpenRowset
- IOpenRowset::OpenRowset
- IParentRowset
- IParentRowset::GetChildRowset
- IRegisterProvider
- IRegisterProvider::GetURLMapping
- IRegisterProvider::SetURLMapping
- IRegisterProvider::UnregisterProvider
- IRow
- IRow::GetColumns
- IRow::GetSourceRowset
- IRow::Open
- IRowChange
- IRowChange::SetColumns
- IRowSchemaChange : IRowChange
- IRowSchemaChange::AddColumns
- IRowSchemaChange::DeleteColumns
- IRowset
- IRowset::AddRefRows
- IRowset::GetData
- IRowset::GetNextRows
- IRowset::ReleaseRows
- IRowset::RestartPosition
- IRowsetBookmark
- IRowsetBookmark::PositionOnBookmark
- IRowsetChange
- IRowsetChange::DeleteRows
- IRowsetChange::InsertRow
- IRowsetChange::SetData
- IRowsetChapterMember
- IRowsetChapterMember:: IsRowInChapter
- IRowsetCurrentIndex
- IRowsetCurrentIndex::GetIndex
- IRowsetCurrentIndex::SetIndex
- IRowsetFind
- IRowsetFind::FindNextRow
- IRowsetIdentity
- IRowsetIdentity::IsSameRow
- IRowsetIndex
- IRowsetIndex::GetIndexInfo
- IRowsetIndex::Seek
- IRowsetIndex::SetRange
- IRowsetInfo
- IRowsetInfo::GetProperties
- IRowsetInfo::GetReferencedRowset
- IRowsetInfo::GetSpecification
- IRowsetLocate : IRowset
- IRowsetLocate::Compare
- IRowsetLocate::GetRowsAt
- IRowsetLocate::GetRowsByBookmark
- IRowsetLocate::Hash
- IRowsetNotify
- IRowsetNotify::OnFieldChange
- IRowsetNotify::OnRowChange
- IRowsetNotify::OnRowsetChange
- IRowsetRefresh
- IRowsetRefresh::GetLastVisibleData
- IRowsetRefresh::RefreshVisibleData
- IRowsetResynch
- IRowsetResynch::GetVisibleData
- IRowsetResynch::ResynchRows
- IRowsetScroll : IRowsetLocate
- IRowsetScroll::GetApproximatePosition
- IRowsetScroll::GetRowsAtRatio
- IRowsetUpdate : IRowsetChange
- IRowsetUpdate::GetOriginalData
- IRowsetUpdate::GetPendingRows
- IRowsetUpdate::GetRowStatus
- IRowsetUpdate::Undo
- IRowsetUpdate::Update
- IRowsetView
- IRowsetView::CreateView
- IRowsetView::GetView
- IScopedOperations : IBindResource
- IScopedOperations::Copy
- IScopedOperations::Delete
- IScopedOperations::Move
- IScopedOperations::OpenRowset
- ISequentialStream
- ISequentialStream : IUnknown
- ISequentialStream::Read
- ISequentialStream::Write
- ISessionProperties
- ISessionProperties::GetProperties
- ISessionProperties::SetProperties
- ISourcesRowset
- ISourcesRowset::GetSourcesRowset
- ISQLErrorInfo
- ISQLErrorInfo::GetSQLInfo
- ISupportErrorInfo
- ISupportErrorInfo:: InterfaceSupportsErrorInfo
- ITableCreation : ITableDefinition
- ITableCreation::GetTableDefinition
- ITableDefinition
- ITableDefinition::AddColumn
- ITableDefinition::CreateTable
- ITableDefinition::DropColumn
- ITableDefinition::DropTable
- ITableDefinitionWithConstraints : ITableCreation
- ITableDefinitionWithConstraints::AddConstraint
- ITableDefinitionWithConstraints::CreateTableWithConstraints
- ITableDefinitionWithConstraints::DropConstraint
- ITransaction
- ITransaction::Abort
- ITransaction::Commit
- ITransaction::GetTransactionInfo
- ITransactionJoin
- ITransactionJoin::GetOptionsObject
- ITransactionJoin::JoinTransaction
- ITransactionLocal : ITransaction
- ITransactionLocal::GetOptionsObject
- ITransactionLocal::StartTransaction
- ITransactionObject
- ITransactionObject::GetTransactionObject
- ITransactionOptions
- ITransactionOptions::GetOptions
- ITransactionOptions::SetOptions
- IViewChapter
- IViewChapter::GetSpecification
- IViewChapter::OpenViewChapter
- IViewFilter
- IViewFilter::GetFilter
- IViewFilter::GetFilterBindings
- IViewFilter::SetFilter
- IViewRowset
- IViewRowset::GetSpecification
- IViewRowset::OpenViewRowset
- IViewSort
- IViewSort::GetSortOrder
- IViewSort::SetSortOrder
- OLE DB Core Components Interfaces
- IDataInitialize
- IDataInitialize::CreateDBInstance
- IDataInitialize::CreateDBInstanceEx
- IDataInitialize::GetDataSource
- IDataInitialize::GetInitializationString
- IDataInitialize::LoadStringFromStorage
- IDataInitialize::WriteStringToStorage
- IDBPromptInitialize
- IDBPromptInitialize::PromptDataSource
- IDBPromptInitialize::PromptFileName
- OLE DB for OLAP Interfaces
- IMDDataset
- IMDDataset::FreeAxisInfo
- IMDDataset::GetAxisInfo
- IMDDataset::GetAxisRowset
- IMDDataset::GetCellData
- IMDDataset::GetSpecification
- IMDFind
- IMDFind::FindCell
- IMDFind::FindTuple
- IMDRangeRowset
- IMDRangeRowset::GetRangeRowset
- Part 5 Appendixes
- Appendix A: Data Types
- Type Indicators
- Precision of Numeric Data Types
- Fixed-Length Data Types
- Variable-Length Data Types
- Data Type Conversion Rules
- Conversion Tables
- Conversions Involving Strings
- Conversions Involving Numeric Values
- Conversions Involving DBTYPE_NUMERIC or DBTYPE_DECIMAL
- Conversions Involving VARIANTs
- Conversions Involving PROPVARIANTs
- Conversions Involving DBTYPE_BYREF
- Conversions Involving DBTYPE_ARRAY
- Conversions Involving DBTYPE_VECTOR
- Appendix B: Schema Rowsets
- ASSERTIONS Rowset
- CATALOGS Rowset
- CHARACTER_SETS Rowset
- CHECK_CONSTRAINTS Rowset
- CHECK_CONSTRAINTS_BY_TABLE Rowset
- COLLATIONS Rowset
- COLUMN_DOMAIN_USAGE Rowset
- COLUMN_PRIVILEGES Rowset
- COLUMNS Rowset
- CONSTRAINT_COLUMN_USAGE Rowset
- CONSTRAINT_TABLE_USAGE Rowset
- FOREIGN_KEYS Rowset
- INDEXES Rowset
- KEY_COLUMN_USAGE Rowset
- PRIMARY_KEYS Rowset
- PROCEDURE_COLUMNS Rowset
- PROCEDURE_PARAMETERS Rowset
- PROCEDURES Rowset
- PROVIDER_TYPES Rowset
- REFERENTIAL_CONSTRAINTS Rowset
- SCHEMATA Rowset
- SQL_LANGUAGES Rowset
- STATISTICS Rowset
- TABLE_CONSTRAINTS Rowset
- TABLE_PRIVILEGES Rowset
- TABLES_INFO Rowset
- TABLES Rowset
- TABLE_STATISTICS Rowset
- TRANSLATIONS Rowset
- USAGE_PRIVILEGES Rowset
- VIEW_COLUMN_USAGE Rowset
- VIEWS Rowset
- VIEW_TABLE_USAGE Rowset
- Appendix C: OLE DB Properties
- Property Sets
- Properties by Property Groups
- Column Property Group
- Data Source Property Group
- Data Source Creation Property Group
- Data Source Information Property Group
- Index Property Group
- Initialization Property Group
- Rowset Property Group
- Session Property Group
- Stream Property Group
- Table Property Group
- View Property Group
- Properties (Alphabetical)
- DBPROP_ABORTPRESERVE
- DBPROP_ACCESSORDER
- DBPROP_ACTIVESESSIONS
- DBPROP_ALTERCOLUMN
- DBPROP_APPENDONLY
- DBPROP_ASYNCTXNABORT
- DBPROP_ASYNCTXNCOMMIT
- DBPROP_AUTH_CACHE_AUTHINFO
- DBPROP_AUTH_ENCRYPT_PASSWORD
- DBPROP_AUTH_INTEGRATED
- DBPROP_AUTH_MASK_PASSWORD
- DBPROP_AUTH_PASSWORD
- DBPROP_AUTH_PERSIST_ENCRYPTED
- DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO
- DBPROP_AUTH_USERID
- DBPROP_BLOCKINGSTORAGEOBJECTS
- DBPROP_BOOKMARKINFO
- DBPROP_BOOKMARKS
- DBPROP_BOOKMARKSKIPPED
- DBPROP_BOOKMARKTYPE
- DBPROP_BYREFACCESSORS
- DBPROP_CACHEDEFERRED
- DBPROP_CANFETCHBACKWARDS
- DBPROP_CANHOLDROWS
- DBPROP_CANSCROLLBACKWARDS
- DBPROP_CATALOGLOCATION
- DBPROP_CATALOGTERM
- DBPROP_CATALOGUSAGE
- DBPROP_CHANGEINSERTEDROWS
- DBPROP_CLIENTCURSOR
- DBPROP_COL_AUTOINCREMENT
- DBPROP_COL_DEFAULT
- DBPROP_COL_DESCRIPTION
- DBPROP_COL_FIXEDLENGTH
- DBPROP_COL_INCREMENT
- DBPROP_COL_ISLONG
- DBPROP_COL_NULLABLE
- DBPROP_COL_PRIMARYKEY
- DBPROP_COL_SEED
- DBPROP_COLUMNDEFINITION
- DBPROP_COLUMNLCID
- DBPROP_COLUMNRESTRICT
- DBPROP_COL_UNIQUE
- DBPROP_COMMANDTIMEOUT
- DBPROP_COMMITPRESERVE
- DBPROP_COMSERVICES
- DBPROP_CONCATNULLBEHAVIOR
- DBPROP_CONNECTIONSTATUS
- DBPROP_CURRENTCATALOG
- DBPROP_DATASOURCENAME
- DBPROP_DATASOURCEREADONLY
- DBPROP_DATASOURCE_TYPE
- DBPROP_DBMSNAME
- DBPROP_DBMSVER
- DBPROP_DEFERRED
- DBPROP_DELAYSTORAGEOBJECTS
- DBPROP_DSOTHREADMODEL
- DBPROP_FILTERCOMPAREOPS
- DBPROP_FINDCOMPAREOPS
- DBPROP_GENERATEURL
- DBPROP_GROUPBY
- DBPROP_HETEROGENEOUSTABLES
- DBPROP_HIDDENCOLUMNS
- DBPROP_IAccessor
- DBPROP_IBindResource
- DBPROP_IChapteredRowset
- DBPROP_IColumnsInfo
- DBPROP_IColumnsInfo2
- DBPROP_IColumnsRowset
- DBPROP_IConnectionPointContainer
- DBPROP_IConvertType
- DBPROP_ICreateRow
- DBPROP_IDBAsynchStatus
- DBPROP_IDENTIFIERCASE
- DBPROP_IGetRow
- DBPROP_IGetSession
- DBPROP_IGetSourceRow
- DBPROP_ILockBytes
- DBPROP_IMMOBILEROWS
- DBPROP_IMultipleResults
- DBPROP_INDEX_AUTOUPDATE
- DBPROP_INDEX_CLUSTERED
- DBPROP_INDEX_FILLFACTOR
- DBPROP_INDEX_INITIALSIZE
- DBPROP_INDEX_NULLCOLLATION
- DBPROP_INDEX_NULLS
- DBPROP_INDEX_PRIMARYKEY
- DBPROP_INDEX_SORTBOOKMARKS
- DBPROP_INDEX_TEMPINDEX
- DBPROP_INDEX_TYPE
- DBPROP_INDEX_UNIQUE
- DBPROP_INIT_ASYNCH
- DBPROP_INIT_BINDFLAGS
- DBPROP_INIT_CATALOG
- DBPROP_INIT_DATASOURCE
- DBPROP_INIT_GENERALTIMEOUT
- DBPROP_INIT_HWND
- DBPROP_INIT_IMPERSONATION_LEVEL
- DBPROP_INIT_LCID
- DBPROP_INIT_LOCATION
- DBPROP_INIT_LOCKOWNER
- DBPROP_INIT_MODE
- DBPROP_INIT_OLEDBSERVICES
- DBPROP_INIT_PROMPT
- DBPROP_INIT_PROTECTION_LEVEL
- DBPROP_INIT_PROVIDERSTRING
- DBPROP_INIT_TIMEOUT
- DBPROP_IParentRowset
- DBPROP_IRow
- DBPROP_IRowChange
- DBPROP_IRowSchemaChange
- DBPROP_IRowset
- DBPROP_IRowsetBookmark
- DBPROP_IRowsetChange
- DBPROP_IRowsetCurrentIndex
- DBPROP_IRowsetFind
- DBPROP_IRowsetIdentity
- DBPROP_IRowsetIndex
- DBPROP_IRowsetInfo
- DBPROP_IRowsetLocate
- DBPROP_IRowsetRefresh
- DBPROP_IRowsetScroll
- DBPROP_IRowsetUpdate
- DBPROP_IRowsetView
- DBPROP_IScopedOperations
- DBPROP_ISequentialStream
- DBPROP_IStorage
- DBPROP_IStream
- DBPROP_ISupportErrorInfo
- DBPROP_IViewChapter
- DBPROP_IViewFilter
- DBPROP_IViewRowset
- DBPROP_IViewSort
- DBPROP_LITERALBOOKMARKS
- DBPROP_LITERALIDENTITY
- DBPROP_LOCKMODE
- DBPROP_MAXINDEXSIZE
- DBPROP_MAXOPENCHAPTERS
- DBPROP_MAXOPENROWS
- DBPROP_MAXORSINFILTER
- DBPROP_MAXPENDINGROWS
- DBPROP_MAXROWS
- DBPROP_MAXROWSIZE
- DBPROP_MAXROWSIZEINCLUDESBLOB
- DBPROP_MAXSORTCOLUMNS
- DBPROP_MAXTABLESINSELECT
- DBPROP_MAYWRITECOLUMN
- DBPROP_MEMORYUSAGE
- DBPROP_MULTIPLECONNECTIONS
- DBPROP_MULTIPLEPARAMSETS
- DBPROP_MULTIPLERESULTS
- DBPROP_MULTIPLESTORAGEOBJECTS
- DBPROP_MULTITABLEUPDATE
- DBPROP_NOTIFICATIONGRANULARITY
- DBPROP_NOTIFICATIONPHASES
- DBPROP_NOTIFYCOLUMNSET
- DBPROP_NOTIFYROWDELETE
- DBPROP_NOTIFYROWFIRSTCHANGE
- DBPROP_NOTIFYROWINSERT
- DBPROP_NOTIFYROWRESYNCH
- DBPROP_NOTIFYROWSETCHANGED
- DBPROP_NOTIFYROWSETRELEASE
- DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE
- DBPROP_NOTIFYROWUNDOCHANGE
- DBPROP_NOTIFYROWUNDODELETE
- DBPROP_NOTIFYROWUNDOINSERT
- DBPROP_NOTIFYROWUPDATE
- DBPROP_NULLCOLLATION
- DBPROP_OLEOBJECTS
- DBPROP_OPENROWSETSUPPORT
- DBPROP_ORDERBYCOLUMNSINSELECT
- DBPROP_ORDEREDBOOKMARKS
- DBPROP_OTHERINSERT
- DBPROP_OTHERUPDATEDELETE
- DBPROP_OUTPUTENCODING
- DBPROP_OUTPUTPARAMETERAVAILABILITY
- DBPROP_OUTPUTSTREAM
- DBPROP_OWNINSERT
- DBPROP_OWNUPDATEDELETE
- DBPROP_PERSISTENTIDTYPE
- DBPROP_PREPAREABORTBEHAVIOR
- DBPROP_PREPARECOMMITBEHAVIOR
- DBPROP_PROCEDURETERM
- DBPROP_PROVIDERFRIENDLYNAME
- DBPROP_PROVIDERMEMORY
- DBPROP_PROVIDERFILENAME
- DBPROP_PROVIDEROLEDBVER
- DBPROP_PROVIDERVER
- DBPROP_QUICKRESTART
- DBPROP_QUOTEDIDENTIFIERCASE
- DBPROP_REENTRANTEVENTS
- DBPROP_REMOVEDELETED
- DBPROP_REPORTMULTIPLECHANGES
- DBPROP_RESETDATASOURCE
- DBPROP_RETURNPENDINGINSERTS
- DBPROP_ROW_BULKOPS
- DBPROP_ROWRESTRICT
- DBPROP_ROWSET_ASYNCH
- DBPROP_ROWSETCONVERSIONSONCOMMAND
- DBPROP_ROWTHREADMODEL
- DBPROP_SCHEMATERM
- DBPROP_SCHEMAUSAGE
- DBPROP_SERVERCURSOR
- DBPROP_SERVERDATAONINSERT
- DBPROP_SERVERNAME
- DBPROP_SESS_AUTOCOMMITISOLEVELS
- DBPROP_SKIPROWCOUNTRESULTS
- DBPROP_SORTONINDEX
- DBPROP_SQLSUPPORT
- DBPROP_STRONGIDENTITY
- DBPROP_STRUCTUREDSTORAGE
- DBPROP_SUBQUERIES
- DBPROP_SUPPORTEDTXNDDL
- DBPROP_SUPPORTEDTXNISOLEVELS
- DBPROP_SUPPORTEDTXNISORETAIN
- DBPROP_TABLESTATISTICS
- DBPROP_TABLETERM
- DBPROP_TBL_TEMPTABLE
- DBPROP_TRANSACTEDOBJECT
- DBPROP_UNIQUEROWS
- DBPROP_UPDATABILITY
- DBPROP_USERNAME
- MDPROP_AGGREGATECELL_UPDATE
- MDPROP_AXES
- MDPROP_FLATTENING_SUPPORT
- MDPROP_MDX_CASESUPPORT
- MDPROP_MDX_DESCFLAGS
- MDPROP_MDX_FORMULAS
- MDPROP_MDX_JOINCUBES
- MDPROP_MDX_MEMBER_FUNCTIONS
- MDPROP_MDX_NONMEASURE_EXPRESSIONS
- MDPROP_MDX_NUMERIC_FUNCTIONS
- MDPROP_MDX_OBJQUALIFICATION
- MDPROP_MDX_OUTERREFERENCE
- MDPROP_MDX_QUERYBYPROPERTY
- MDPROP_MDX_RANGEROWSET
- MDPROP_MDX_SET_FUNCTIONS
- MDPROP_MDX_SLICER
- MDPROP_MDX_STRING_COMPOP
- MDPROP_NAMED_LEVELS
- MDPROP_VISUALMODE
- Appendix D: Cotypes, Structures, and Enumerated Types
- OLE DB CoTypes
- OLE DB Structures and Enumerated Types
- Appendix E: Interface Summary
- Appendix F: Sample OLE DB Consumer Application
- Appendix G: OLE DB Methods to Interfaces Table
- Appendix H: Data Type Conversion Interfaces
- Data Conversion Library
- Library-Supported Data Type Conversions
- Conversions Supported from Data Type I1
- Conversions Supported from Data Type I2
- Conversions Supported from Data Type I4
- Conversions Supported from Data Type I8
- Conversions Supported from Data Type UI1
- Conversions Supported from Data Type UI2
- Conversions Supported from Data Type UI4
- Conversions Supported from Data Type UI8
- Conversions Supported from Data Type R4
- Conversions Supported from Data Type R8
- Conversions Supported from Data Type BOOL
- Conversions Supported from Data Type ERROR
- Conversions Supported from Data Type BSTR
- Conversions Supported from Data Type STR
- Conversions Supported from Data Type WSTR
- Conversions Supported from Data Type BYTES
- Conversions Supported from Data Type DATE
- Conversions Supported from Data Type DBDATE
- Conversions Supported from Data Type DBTIME
- Conversions Supported from Data Type DBTIMESTAMP
- Conversions Supported from Data Type FILETIME
- Conversions Supported from Data Type GUID
- Conversions Supported from Data Type CY
- Conversions Supported from Data Type DECIMAL
- Conversions Supported from Data Type NUMERIC
- Conversions Supported from Data Type VARNUMERIC
- Conversions Supported from Data Type VARIANT
- Conversions Supported from Data Type PROPVARIANT
- Conversions Supported from Data Type IDispatch
- Conversions Supported from Data Type IUnknown
- IDataConvert
- IDataConvert::CanConvert
- IDataConvert::DataConvert
- IDataConvert::GetConversionSize
- IDCInfo
- IDCInfo::GetInfo
- IDCInfo::SetInfo
- Appendix I: Row Position Object
- IRowPosition
- IRowPosition Code Example
- IRowPosition::ClearRowPosition
- IRowPosition::GetRowPosition
- IRowPosition::GetRowset
- IRowPosition::Initialize
- IRowPosition::SetRowPosition
- IRowPositionChange
- IRowPositionChange::OnRowPositionChange
- OLE DB Glossary
- About This Electronic Book
- About Microsoft Press
Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
ISBN: 0735605904
EAN: 2147483647
EAN: 2147483647
Year: 1998
Pages: 1083
Pages: 1083
Authors: Microsoft Corporation