Programming ODBC SQL Server Applications
Getting Started with ODBC
ODBC Syntax Conventions
System Requirements for ODBC
SQL Server ODBC Driver
SQL Server
Network Software
Installing the SQL Server ODBC Driver
Upgrading the Catalog Stored Procedures (ODBC)
Adding a Data Source
Deleting a Data Source
Connecting to a SQL Server Data Source
Using odbcping to Verify a Connection
Creating an ODBC Application
Asynchronous Mode and SQLCancel
Multithreaded Applications
Communicating with SQL Server
Allocating an Environment Handle
Allocating a Connection Handle
SQL Server ODBC Data Sources
Connecting to a Data Source
Disconnecting from a Data Source
Executing Queries
Allocating a Statement Handle
Constructing an SQL Statement
Constructing SQL Statements for Cursors
Using Statement Parameters
Binding Parameters
Executing Statements
Direct Execution
Prepared Execution
Procedures
Batches of Statements
Effects of SQL-92 Options
Freeing a Statement Handle
Processing Results
Determining the Characteristics of a Result Set
Assigning Storage (Binding)
Fetching Result Data
Mapping Data Types
Data Type Usage
Autotranslation of Character Data
Using Cursors
How Cursors Are Implemented
Using Default Result Sets
Using Server Cursors
ODBC Cursor Library
Cursor Types
Cursor Behaviors
Cursor Properties
Cursor Rowset Size
Cursor Concurrency
Cursor Transaction Isolation Level
Cursor Programming Details (ODBC)
Implicit Cursor Conversions (ODBC)
Using Autofetch with ODBC Cursors
Fast Forward-Only Cursors (ODBC)
Scrolling and Fetching Rows
Bookmarking Rows
Positioned Updates (ODBC)
Performing Transactions
Transactions in ODBC
Performing Distributed Transactions
Handling Errors and Messages
Processing Statements That Generate Messages
Diagnostic Records and Fields
Native Error Numbers
SQLSTATE (ODBC Error Codes)
Error Messages
Running Stored Procedures
Calling a Stored Procedure
Batching Stored Procedure Calls
Processing Stored Procedure Results
Using Catalog Functions
Performing Bulk Copy Operations
Logged and Nonlogged Bulk Copies
Using Data Files and Format Files
Bulk Copying from Program Variables
Managing Bulk Copy Batch Sizes
Bulk Copying text and image Data
Converting from DB-Library to ODBC Bulk Copy
Managing text and image Columns
Bound vs. Unbound text and image Columns
Logged vs. Unlogged Modifications
Data-at-execution and text, ntext, or image Columns
Connecting to a Failover Server
Profiling ODBC Driver Performance
SQL Server ODBC Driver Programmer's Reference
ODBC API Implementation Details
SQLBindCol
SQLBindParameter
SQLBrowseConnect
SQLCloseCursor
SQLColAttribute
SQLColumnPrivileges
SQLColumns
SQLConfigDataSource
SQLDescribeCol
SQLDescribeParam
SQLDriverConnect
SQLDrivers
SQLEndTran
SQLFetchScroll
SQLForeignKeys
SQLFreeHandle
SQLFreeStmt
SQLGetConnectAttr
SQLGetCursorName
SQLGetData
SQLGetDescField
SQLGetDiagField
SQLGetFunctions
SQLGetInfo
SQLGetStmtAttr
SQLGetTypeInfo
SQLMoreResults
SQLNativeSql
SQLNumResultCols
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLPutData
SQLRowCount
SQLSetConnectAttr
SQLSetEnvAttr
SQLSetStmtAttr
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
SQLTables
SQL Server Driver Extensions
Bulk-Copy Functions
bcp_batch
bcp_bind
bcp_colfmt
bcp_collen
bcp_colptr
bcp_columns
bcp_control
bcp_done
bcp_exec
bcp_getcolfmt
bcp_init
bcp_moretext
bcp_readfmt
bcp_sendrow
bcp_setcolfmt
bcp_writefmt
Schema Functions Supporting Distributed Queries
SQLLinkedCatalogs
SQLLinkedServers
ODBC Samples
Cursors and Transactions, Data Entry and Concurrency
LoadData
Performance
ODBC Bulk Copy Sample
COMPUTE Clause and Multiple Result Sets