Title | Next | Index

Table of Contents

List of Tables

Preface

What Is DataDirect Connect ADO?
Using This Book
Other Connect ADO Documentation
Conventions Used in This Book
Ordering Printed Books
Contacting Technical Support

1 Introduction

Using Connect ADO Data Providers
Developing Applications for Connect ADO
Enabling MTS
Support for Windows

2 Using the DataDirect Configuration Manager

What Is a Connect ADO Data Source?
Connecting to a Data Source
Overview of the Configuration Manager
Defining a Data Source
Modifying a Data Source
Renaming a Data Source
Deleting a Data Source
Changing Data Source Directories
Copying a Data Source
Making a Connection
Defining Default Setup Options
Creating a Template Data Source File
Creating a Master Data Source File

3 Connect ADO for Informix

Creating Data Sources
Configuring Data Sources
Informix ADO Provider Connection Dialog Box
Connecting to a Data Source Using a Connection String
Data Types
Isolation and Lock Levels Supported
Using Sessions and Transactions
Threading Model Supported
Schema Rowsets Supported
Using Keyset-driven Cursors
MTS Support

4 Connect ADO for Oracle

Creating Data Sources
Configuring Data Sources
Oracle ADO Provider Connection Dialog Box
Connecting to a Data Source Using a Connection String
Data Types
Isolation and Lock Levels Supported
Using Sessions and Transactions
Threading Model Supported
Schema Rowsets Supported
Using Keyset-driven Cursors
MTS Support
Custom Error Object Support
Stored Procedures

5 Connect ADO for Sybase

Creating Data Sources
Configuring Data Sources
Sybase ADO Provider Connection Dialog Box
Connecting to a Data Source Using a Connection String
Data Types
Isolation and Lock Levels Supported
Using Sessions and Transactions
Threading Model Support
Schema Rowsets Supported
MTS Support
Custom Error Object Support

6 Connect ADO for XML

Terminology
Using XML With the XML Data Provider
Formats for XML Files
Hierarchical-Formatted XML Document Support
Column Data Types
Defining Locations
Specifying Table Names in SQL Statements
Creating Data Sources
Configuring Data Sources
XML ADO Provider Connection Dialog Box
Connecting to a Data Source Using a Connection String
Using Hints for Tabular-Formatted XML Documents
Data Types
Threading Model Supported
Schema Rowset Support

7 Developing ADO Applications for Connect ADO Data Providers

Mapping Data Types
Persisting Information
Using Rowsets
Unicode Support
Data Shaping
Error Handling
Custom Error Objects

8 Connect ADO for Microsoft SQL Server

Creating Data Sources
Connecting to a SQL Server Database
Developing Applications for the SQL Server Provider

A OLE DB Interfaces and Properties

OLE DB Objects and Interfaces
Supported OLE DB Properties

B ADO Methods and Properties

Using ADO Methods in Connect ADO
Defining ADO Properties for Connect ADO Data Providers

C Locking and Isolation Levels

Locking
Isolation Levels
Locking Modes and Levels

Index



Title | Next | Index

Connect ADO User's Guide and Reference

2002, DataDirect Technologies. All rights reserved.