www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Overview
New Features in OpenLink UDA
ODBC Client Components
ADO.NET Data Providers
OLE-DB Client Provider
Server Components Installation
Request Broker Administration
Server Agent Administration
Securing a Multi-Tier connection using SSL
Zero Configuration Networking
JDBC Components
Distributed Transaction Processing (XA)
Real Application Cluster (RAC) / TAF Support
iODBC Driver Manager SDK
Sample Applications
Bugs Fixed
Technical Appendix

Multi-Tier User Guide - Contents

1. Overview
2. New Features in OpenLink UDA
3. ODBC Client Components
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.2. Installation
3.2.3. Data Source Configuration
3.2.4. Tracing Data Sources
3.2.5. Testing Data Sources
3.3. Mac OS X
3.3.2. Installation
3.3.3. Data Source Configuration
3.3.4. Testing Data Sources
3.3.5. 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.8. Oracle 10g Instant Client: Connection String Formats
3.8.1.
4. 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. OLE-DB Client 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.2. Invoking the OpenLink Provider
5.7.3. Connecting from ADO or .Net
5.7.4. Initialization Properties
5.7.5. Initializing and Uninitializing the Data Source Object
5.7.6. Creating a Session
5.7.7. Creating a Rowset
5.7.8. Exposing Metadata
5.7.9. Supported Conversions
5.7.10. Creating and Using Accessors
5.7.11. 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.2. 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.2. 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 Drivers for Java Database Connectivity (JDBC)
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)
13. Real Application Cluster (RAC) / TAF Support
13.1. Real Application Cluster (RAC) / TAF Support
13.1.1. What it is
13.1.2. What you have to do to use it
13.1.3. Related Links
14. iODBC Driver Manager SDK
14.1. iODBC SDK on Unix
14.2. Configuring Data Sources
14.2.3. The Configuration Files
14.2.4. Making a Test Connection
14.2.5. Compiling Sample Program
14.2.6. Developing ODBC Applications
14.2.7. 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.3. Linux & UNIX Based ODBC Sample Applications
15.3.1. ODBCTEST
15.3.2. ODBC Benchmark Application
15.4. Mac OS X
15.4.1. ODBCTEST:
15.5. JDBC Sample Applications &Applets
15.5.1. JDBCDemo Java Application
15.5.2. Rowset Java Application
15.5.3. ScrollDemo2 Java Application
15.5.4. ScrollDemo2 Java Applet
15.5.5. JBench Application
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