documentation
.HELP!
OLE DB and SQL Server Documentation
Creating an OLE DB Application
OLE DB and SQL Server
previous page
next page
OLE DB and SQL Server
Creating an OLE DB Application
Creating an OLE DB application involves these steps:
Establishing a connection to a data source.
Executing a command.
Processing the results.
previous page
start
next page
Menu
Homepage
Table of contents
Programming OLE DB SQL Server Applications
Getting Started with the OLE DB Provider for SQL Server
OLE DB Syntax Conventions
System Requirements for the OLE DB Provider for SQL Server
Installing the OLE DB Provider for SQL Server
Upgrading the Catalog Stored Procedures (OLE DB)
Creating an OLE DB Application
Establishing a Connection to a Data Source
Executing a Command
Processing Results
Compiling OLE DB Applications
About OLE DB Properties
Data Source Objects
Data Source Properties
Data Source Information Properties
Initialization and Authorization Properties
Sessions
Session Properties
Persisted Data Source Objects
Commands
Command Syntax
Command Parameters
Preparing Commands
Commands Generating Multiple-Rowset Results
Using IMultipleResults to Process Multiple Result Sets
Rowsets
Creating a Rowset with IOpenRowset
Creating Rowsets with ICommand::Execute
Rowset Properties and Behaviors
Rowsets and SQL Server Cursors
Fetching Rows
Next Fetch Position
Fetching a Single Row Using IRow
Using IRow::GetColumns
Fetching BLOB Data Using IRow
Fetching BLOB Data Using IRow::GetColumns and ISequentialStream
Fetching BLOB Data Using IRow::Open and ISequentialStream
Bookmarks
Running Stored Procedures (OLE DB)
Calling a Stored Procedure (OLE DB)
Running User-Defined Functions (OLE DB)
Bulk-Copy Rowsets
Enabling a Session for IRowsetFastLoad
IRowsetFastLoad Rowsets
Updating Data in Rowsets
Updating Data in SQL Server Cursors
Resynchronizing Rows
BLOBs and OLE Objects
Getting Large Data
Setting Large Data
Tables and Indexes
Creating SQL Server Tables
Adding a Column to a SQL Server Table
Removing a Column from a SQL Server Table
Dropping a SQL Server Table
Creating SQL Server Indexes
Dropping a SQL Server Index
Notifications
Data Types (OLE DB)
Data Type Mapping in Rowsets and Parameters
Data Type Mapping in ITableDefinition
Schema Rowset Support in SQLOLEDB
Catalog Stored Procedures
Distributed Query Support in Schema Rowsets
Transactions
Supporting Local Transactions
Supporting Distributed Transactions
Isolation Levels in SQLOLEDB
SQLOLEDB Enumerator
Errors
Return Codes
Information in OLE DB Error Interfaces
SQL Server Error Detail
SQLOLEDB Example: Retrieving Error Information
SQL Server Message Results
SQL Server OLE DB Programmer's Reference
Interfaces (OLE DB)
IRowsetFastLoad (OLE DB)
IRowsetFastLoad::Commit (OLE DB)
IRowsetFastLoad::InsertRow (OLE DB)
ISQLServerErrorInfo (OLE DB)
ISQLServerErrorInfo::GetErrorInfo (OLE DB)
Schema Rowsets (OLE DB)
LINKEDSERVERS Rowset (OLE DB)
Get in touch
Submit feedback about this site to:
[email protected]