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