Object Browser, 237
Object model, ADO 2.5, 13-16
ODBC (Open Database Connectivity)
connecting to data sources, 12, 13, 21, 26, 27-28
and connection pooling, 56-59
converting connection strings to OLE DB, 38-39
and Data Source Names (DSNs), 27, 28, 35-37
future of, 362
message and error handling, 230-32
Oracle drivers, 26, 103
sample driver connection string syntax, 39
SQL Server drivers, 12, 26, 324
Office 2000, 1, 2, 3, 5
OLE DB
and ADO, 11-13
converting connection strings from ODBC to, 38-39
list of providers in Data Link Properties dialog box, 12-13, 21
and Microsoft Data Link, 36, 37, 52
native providers, 12, 26, 28, 29-30
provider message and error handling, 230-32
provider overview, 12-13
and session pooling, 56, 57, 61-62
Shape provider (See Shape provider)
and SQL Server, 39-41, 75, 230-31, 324
and URLs, 4
OLEDB.CHM file, 15
OLE DB Provider for ODBC (MSDASQL)
and RAISERROR messages, 230-31
and session pooling, 61
using for connections, 13, 26, 27-28
On Error Resume Next, 283, 289, 300
Open method
and asynchronous operations, 62-63, 193-95
Connection objects, 27-28, 49, 62
Recordset objects, 126-29, 134, 135, 193, 194, 216, 291
OpenSchema method, 330-31
Oracle, 21, 26, 38, 102-3
ORDER BY clause, 144
OriginalValue property, 175, 207
OUTPUT parameters
ADO limitations, 101, 113
combining with rowsets, 222-26
and GUIDs, 153
passing, 258-61
vs. Recordset objects, 117, 119
vs. rowsets, 220-22, 258-61
and stored procedures, 218, 220-22
in User-Defined Types application, 267-68
Team-Fly |