OpenLink ODBC Driver (Multi-Tier Edition) Documentation

Table of Contents

Preface

1. Conventions

2. Copyright

1. Overview

2. New Features in OpenLink UDA

2.1. New Features in OpenLink UDA v6.0

2.2. New Features in OpenLink UDA v5.2

3. OpenLink ODBC Driver (Multi-Tier Edition) Client Component

3.1. Generic Client for Windows

3.1.1. Installation (32-bit)

3.1.2. Installation (64-bit)

3.1.3. Data Source Configuration

3.1.4. ODBC System & User Data Sources

3.1.5. Creating a File Data Source

3.1.6. Advanced Settings

3.2. Generic Client For Macintosh OS 8.6+

3.2.1. Installation

3.2.2. Data Source Configuration

3.2.3. Tracing Data Sources

3.2.4. Testing Data Sources

3.3. Mac OS X

3.3.1. Installation

3.3.2. Data Source Configuration

3.3.3. Testing Data Sources

3.3.4. Troubleshooting ODBC Connections and Sessions

3.4. Generic Client for UNIX

3.4.1. Installation

3.4.2. Configuration

3.4.3. Sample Application

3.4.4. UDBC Data Source Configuration

3.5. New Features

3.6. Oracle Connection Pooling Support

3.6.1. What it is

3.6.2. Benefits

3.6.3. How it Works

3.6.4. The OpenLink Perspective: what you do to use it

3.7. Multi-Tier-specific Connection-Pooling

3.7.1. Multi-Tier-specific configuration

3.8. Oracle 10g Instant Client: Connection String Formats

3.8.1. OpenLink Multi-Tier Connections using Instant Client

3.8.2. Oracle Client Installation related links

4. OpenLink ADO.NET Data Providers

4.1. Architecture

4.1.1. Managed Data Provider

4.1.2. Unmanaged Data Provider

4.2. Developing .NET Data Provider Application

4.3. OpenLink .NET Data Providers Connect String Attributes

4.3.1. Managed Generic Multi-Tier .NET Data Provider (OpenLink.Data.GenericClient)

4.3.2. Managed Microsoft SQLServer .NET Data Provider (OpenLink.Data.SQLServer)

4.3.3. Managed Sybase .NET Data Provider (OpenLink.Data.Sybase)

4.3.4. Unmanaged .NET Data Provider (OpenLink.Data.OdbcClient)

4.4. OpenLink .NET Data Providers Class Implementation

4.5. OpenLink.Data Namespace

4.5.1. OPLCommand

4.5.2. OPLCommandBuilder

4.5.3. OPLConnect

4.5.4. OPLDataAdapter

4.5.5. OPLDataReader

4.5.6. OPLError

4.5.7. OPLErrorCollection

4.5.8. OPLException

4.5.9. OPLParameter

4.5.10. OPLParameterCollection

4.5.11. OPLRowUpdatedEventArgs

4.5.12. OPLRowUpdatedEventHandler

4.5.13. OPLRowUpdatingEventArgs

4.5.14. OPLRowUpdatingEventHandler

4.5.15. OPLTransaction

4.6. Known Issues

4.6.1. Unsigned Type Handling

4.6.2. Timestamp Precision

4.7. .Net Provider Test Program

4.8. New Features

5. OpenLink OLE-DB Provider

5.1. Testing an OLEDB Connection

5.2. Call Tracing

5.3. Provider Specific Connection Information

5.3.1. Using a Consumer Supplied Prompting Interface

5.3.2. Using a Connection String

5.3.3. Using The DBPROP_INIT_PROVIDERSTRING Property

5.4. Controlling ODBC Cursor Library Usage

5.5. Controlling the Default Bookmark Setting for Rowsets

5.6. Known Issues

5.6.1. General Issues

5.6.2. .Net

5.6.3. Visual Interdev 6

5.6.4. Visual Basic 6 and ADO

5.6.5. SQL Server Data Transformation Services

5.7. Objects and Interfaces Implemented by the OpenLink Provider

5.7.1. Invoking the OpenLink Provider

5.7.2. Connecting from ADO or .Net

5.7.3. Initialization Properties

5.7.4. Initializing and Uninitializing the Data Source Object

5.7.5. Creating a Session

5.7.6. Creating a Rowset

5.7.7. Exposing Metadata

5.7.8. Supported Conversions

5.7.9. Creating and Using Accessors

5.7.10. Rowset MetaData

6. Server Components Installation

6.1. OpenLink License Manager Usage Notes

6.1.1. Background

6.1.2. Single-Tier

6.1.3. Multi-Tier

6.1.4. How to stop/start the OpenLink License Manager

6.1.5. Environment Variables

6.1.6. OpenLink License Manager Networking Considerations

6.2. Product Licensing

6.2.1. Initial License

6.2.2. How to apply the License

6.3. Upgrading the License

6.4. Windows 95/98/NT/XP/2000 Install

6.5. Mac OS X

6.5.1. Installation

6.6. UNIX & Linux Install

6.7. Installed Files & Locations

6.7.1. The "bin" sub-directory:

6.7.2. The "bin/w3config" sub-directory:

6.8. Obtaining Component Details From The Command Line

6.8.1. OpenLink Request Broker:

6.8.2. Web Service Agent:

6.9. Configuring a Firewall for use with UDA Multi-Tier

7. Request Broker Administration

7.1. Request Broker Startup & Shutdown

7.1.1. Startup Options

7.1.2. Shutdown Options

7.1.3. Security

7.1.4. Multiple Request Brokers

7.2. Request Broker Session Parameters

7.2.1. General Information

7.2.2. Using Admin Assistant Wizards

7.2.3. Using Admin Assistant Forms

7.3. OpenLink Session Rules Administration & Configuration Guide

7.3.1. OpenLink Session Rules Concepts

7.3.2. OpenLink Connection Attributes

7.3.3. OpenLink Session Templates

7.3.4. Session Rules Execution Process

7.3.5. Creating Custom Aliases For Use By OpenLink Data Access Clients

7.3.6. Using the Admin Assistant To Create Session Rules

8. Server Agent Administration

8.1. Administration Assistant

8.1.1. Wizard Based Administration

8.1.2. Forms Based Administration

8.2. Agent-Specific Settings

8.2.1. Common Agent Configuration Options

8.2.2. Virtuoso

8.2.3. Informix

8.2.4. Ingres

8.2.5. Progress

8.2.6. Oracle

8.2.7. Sybase

8.2.8. Microsoft SQL Server

8.2.9. TDS

8.2.10. DB2

8.2.11. PostgresSQL

8.2.12. MySQL

8.2.13. OpenLink ODBC Agent Installation & Configuration

8.2.14. OpenLink ODBC-JDBC Agent Bridge Installation & Configuration

8.2.15. OpenLink Proxy Agent

8.3. Database Configuration for Unicode

8.3.1. Oracle 8 & 9

8.3.2. Informix 9.x

8.3.3. Sybase 12.5 +

8.3.4. Progress 9.1 (SQL-92)

8.3.5. DB/2 v7.x

8.3.6. MS SQLServer 2000

8.3.7. Operational Notes

8.4. Obtaining Agent Information

8.4.1. Specific Agent Information

8.5. Linking OpenLink DB Agents

8.5.1. General Linking Approach

8.5.2. Relinking Progress Agents

8.6. Progress Troubleshooting & Advanced Configuration

8.6.1. OpenLink Data Access Components

8.6.2. How OpenLink's Data Access Drivers Connect To Your Progress Database

8.6.3. Initial Connection Problems

8.6.4. Making OpenLink Database Agent Use a Sockets Based IPC

8.6.5. Distributed Databases, Array Fields, Database Triggers

8.6.6. Using OpenLink ODBC, Progress & Microsoft Access

8.6.7. Key Microsoft Access Jet Engines Setting That Can Affect Your OpenLink ODBC Experience

8.7. Application Server Architecture

9. Securing a Multi-Tier connection using SSL

9.1. Overview

9.2. Implementing SSL Encryption

9.2.1. Server-side Configuration for SSL

9.2.2. Client-side Configuration for SSL

9.2.3. Error Messages

10. Zero Configuration Networking

10.1. Introduction

10.2. Server Configuration

10.2.1. Configuration by Rule Book Edit

10.2.2. Configuration by Wizard

10.2.3. Configuration by Form

10.3. Client Configuration

10.3.1. Configuration by Windows ODBC Driver Manager

10.3.2. Configuration by Admin Assistant

11. JDBC Components

11.1. OpenLink JDBC Drivers

11.1.1. New JDBC Driver Packages

11.1.2. New Features & Enhancements

11.2. Downloading Driver Software

11.2.1. OpenLink Web Download Wizard Interaction for obtaining OpenLink Drivers for JDBC Bundle

11.2.2. Download Wizard Interaction for obtaining OpenLink Megathin Drivers for JDBC

11.3. OpenLink Drivers for JDBC Installation & Configuration

11.3.1. Windows 95/98/NT/2000 Based Local Client-Server Environment

11.3.2. Windows 95/98/NT/2000 Based Client-Server (2-Tier Configuration) Environment

11.3.3. Windows 95/98/NT/2000 Based Application-Server (3-Tier Configuration) Environment

11.4. Java Based Local Client-Server

11.4.1. Client Components Installation Process

11.4.2. Server Components Installation

11.4.3. Linux or UNIX Server Components Installation

11.5. Java Based Client-Server (2-Tier) Installation

11.5.1. Windows 95/98/NT/2000 Client Components Installation Process

11.5.2. Linux or UNIX Client Components Installation

11.5.3. Server Components Installation

11.5.4. Linux or UNIX Server Components Installation

11.6. Java Based Application-Server (3-Tier) Installation

11.6.1. Windows 95/98/NT/2000 Client Components Installation Process.

11.6.2. Linux or UNIX Application Server Components Installation

11.6.3. Database Server Components Installation

11.6.4. Mixed Environment Installations

11.7. OpenLink Server Components Configuration

11.8. OpenLink Drivers for JDBC Utilization

11.8.1. OpenLink Driver for JDBC Type 1

11.8.2. OpenLink Driver for JDBC Type 3

11.8.3. Examples

11.9. OpenLink Demonstration Programs

11.9.1. JDBC Compliant Applet Demos

11.9.2. JDBCDemo

11.9.3. ScrollDemo

11.9.4. ScrollDemo2

11.9.5. RowSetDemo

11.9.6. JDBC compliant Application Demos

11.10. Important Multi-User JDBC Solution Development & Utilization Issues

11.10.1. Sensitivity To Changes In Underlying Database

11.10.2. Concurrency Control

11.11. JDBC 3 Driver Classes

11.11.1. Class BaseRowSet

11.11.2. Class OPLCachedRowSet

11.11.3. Class OPLConnectionPoolDataSource

11.11.4. Class OPLDataSource

11.11.5. Class OPLDataSourceFactory

11.11.6. Class OPLJdbcRowSet

11.11.7. Class OPLPooledConnection

11.11.8. Class OPLPoolStatistic

11.11.9. Class OPLRowSetMetaData

11.12. New Features

12. Distributed Transaction Processing (XA)

12.1. Distributed Transaction Processing (DTP)

12.1.1. X/Open DTP Model

12.1.2. OpenLink Resource Manager XA Interface Implementation

12.1.3. Configuring Databases for XA support

12.1.4. OpenLink XA Connection String Formats

12.1.5. Tracing XA calls in OpenLink ODBC Drivers

12.1.6. Enabling XA Transactions on Windows XP SP2 and Windows Server 2003

12.1.7. Using OpenLink Drivers with Tuxedo on Unix

13. Real Application Cluster (RAC) / TAF Support

13.1. What you have to do to use it

13.1.1. Configuration

13.1.2. Programmatic Considerations

13.2. Related Links

14. OpenLink ODBC Driver Manager (iODBC SDK)

14.1. iODBC SDK on Unix

14.2. Configuring Data Sources

14.2.1. The Configuration Files

14.2.2. Making a Test Connection

14.2.3. Compiling Sample Program

14.2.4. Developing ODBC Applications

14.2.5. Further Reading:

14.3. Linking iODBC and ODBC Applications on Mac OS

14.3.1. Mac OS Classic

14.3.2. Mac OS X

14.3.3. References

14.3.4. Porting Mac OS Classic ODBC applications to Mac OS X

15. Sample Applications

15.1. Binary & Source File Locations

15.1.1. ODBC Demonstration Applications

15.1.2. JDBC Demonstration Applications

15.2. Windows 95/98/NT/2000 Based ODBC Sample Applications

15.2.1. C++ Demo

15.2.2. ODBC Bench Test 32

15.2.3. Linux & UNIX Based ODBC Sample Applications

15.2.4. Mac OS X

15.2.5. JDBC Sample Applications &Applets

16. Bugs Fixed

17. Technical Appendix

17.1. Rulebook Settings

17.1.1. [Request Broker]

17.1.2. [Protocol TCP]

17.1.3. [Protocol SPX]

17.1.4. [Protocol DECnet]

17.1.5. [Communications]

17.1.6. [ZeroConf]

17.1.7. [Security]

17.1.8. [generic_agentname]

17.1.9. [Domain Aliases]

17.1.10. [Database Aliases]

17.1.11. [User Aliases]

17.1.12. [Opsys Aliases]

17.1.13. [Machine Aliases]

17.1.14. [Application Aliases]

17.1.15. [Mapping Rules]

17.2. Error Codes

17.3. Broker Log Levels

17.4. ODBC to Jet Data Type Mapping

17.4.1. Overview

17.4.2. ODBC to Jet Data Type Mapping

17.4.3. Jet Data Type Ranges

17.4.4. References

17.4.5. Informix Jet Support

17.4.6. Oracle Jet Support

17.5. SQL Server 2000 – Connection Options

17.5.1. Connection Option Parameters

17.5.2. Entry Format

17.5.3. Disallowed Keywords