Index_O

Team-Fly

Index

O

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


ADO Examples and Best Practices
Ado Examples and Best Practices
ISBN: 189311516X
EAN: 2147483647
Year: 2000
Pages: 106

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net