Universal Data Access Drivers Documentation

Table of Contents

OpenLink ODBC Driver (Multi-Tier Edition) Documentation
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
OpenLink ODBC Driver (Express Edition) User Guide
1. OpenLink ODBC Driver (Express Edition) Documentation
1.1. Overview
1.1.1. Driver Architecture
1.1.2. System Requirements
1.1.3. Installation and Configuration Guide
1.1.4. OpenLink Express Edition Drivers Installation and Configuration on Mac OS X
2. Product Licensing
2.1. OpenLink License Manager Usage Notes
2.1.1. Background
2.1.2. Single-Tier
2.1.3. Multi-Tier
2.1.4. How to stop/start the OpenLink License Manager
2.1.5. Environment Variables
2.1.6. OpenLink License Manager Networking Considerations
3. OpenLink ODBC Driver for DB2 (Express Edition)
3.1. OpenLink ODBC Driver for DB2 (Express Edition) for Mac OS X
3.1.1. Installation Guide
3.1.2. Configuration
3.2. OpenLink ODBC Driver for DB2 (Express Edition) for Windows
3.2.1. Installation
3.2.2. Configuration
4. OpenLink ODBC Driver for Firebird (Express Edition)
4.1. OpenLink ODBC Driver for Firebird (Express Edition) for Mac OS X
4.1.1. Installation Guide
4.1.2. Configuration
4.2. OpenLink ODBC Driver for Firebird (Express Edition) for Windows
4.2.1. Installation
4.2.2. Configuration
5. OpenLink ODBC Driver for Informix (Express Edition)
5.1. OpenLink ODBC Driver for Informix (Express Edition) for Mac OS X
5.1.1. Installation Guide
5.1.2. Configuration
5.2. OpenLink ODBC Driver for Informix (Express Edition) for Windows
5.2.1. Installation
5.2.2. Configuration
6. OpenLink ODBC Driver for Ingres (Express Edition)
6.1. OpenLink ODBC Driver for Ingres (Express Edition) for Mac OS X
6.1.1. Installation Guide
6.1.2. Configuration
6.2. OpenLink ODBC Driver for Ingres (Express Edition) for Windows
6.2.1. Installation
6.2.2. Configuration
7. OpenLink ODBC Driver for MySQL (Express Edition)
7.1. OpenLink ODBC Driver for MySQL (Express Edition) for Mac OS X
7.1.1. Installation Guide
7.1.2. Configuration
7.2. OpenLink ODBC Driver for MySQL (Express Edition) for Windows
7.2.1. Installation
7.2.2. Configuration
8. OpenLink ODBC Driver for Oracle (Express Editon)
8.1. OpenLink ODBC Driver for Oracle (Express Editon) for Mac OS X
8.1.1. Installation Guide
8.1.2. Configuration
8.2. OpenLink ODBC Driver for Oracle (Express Editon) for Windows
8.2.1. Installation
8.2.2. Configuration
9. OpenLink ODBC Driver for PostgreSQL (Express Edition)
9.1. OpenLink ODBC Driver for PostgreSQL (Express Edition) for Mac OS X
9.1.1. Installation Guide
9.1.2. Configuration
9.2. OpenLink ODBC Driver for PostgreSQL (Express Edition) for Windows
9.2.1. Installation
9.2.2. Configuration
10. OpenLink ODBC Driver for SQL Server (Express Editon)
10.1. OpenLink ODBC Driver for SQL Server (Express Editon) for Mac OS X
10.1.1. Installation Guide
10.1.2. Configuration
10.2. OpenLink ODBC Driver for SQL Server (Express Editon) for Windows
10.2.1. Installation
10.2.2. Configuration
11. OpenLink ODBC Driver for Sybase (Express Editon)
11.1. OpenLink ODBC Driver for Sybase (Express Editon) for Mac OS X
11.1.1. Installation Guide
11.1.2. Configuration
11.2. OpenLink ODBC Driver for Sybase (Express Editon) for Windows
11.2.1. Installation
11.2.2. Configuration
OpenLink ODBC Driver (Lite Edition) Documentation
Preface
1. Conventions
2. Copyright
1. Overview
1.1. OpenLink ODBC Driver (Single-Tier Edition) Introduction
1.1.1. About ODBC
1.1.2. How ODBC Works
1.1.3. What You Can Do With ODBC
1.2. Using ODBC on a PC
1.3. Finding Further Information About ODBC & Utilities
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 (Single-Tier Edition) System Requirements and Basic Instructions
3.1. Installing OpenLink Single-Tier Drivers for ODBC
3.2. System Requirements
3.2.1. Software Requirements
3.2.2. Hardware Requirements
3.3. Downloading OpenLink Single-Tier Drivers for ODBC
4. OpenLink ODBC Driver (Single-Tier Edition) Installation
4.1. OpenLink License Manager Usage Notes
4.1.1. Background
4.1.2. Single-Tier
4.1.3. Multi-Tier
4.1.4. How to stop/start the OpenLink License Manager
4.1.5. Environment Variables
4.1.6. OpenLink License Manager Networking Considerations
4.2. Windows (32-bit)
4.3. Windows (64-bit)
4.4. UNIX & Linux
4.5. Mac OS X
4.6. Product Licensing
4.6.1. Initial License
4.6.2. How to apply the License
4.6.3. Upgrading the License
4.6.4. See Also
4.7. Oracle 10g Instant Client: Connection String Formats
4.7.1. OpenLink Single-Tier Connections using Instant Client
4.7.2. Oracle Instant Client Related Links
4.8. Oracle Real Application Cluster (RAC) / TAF Support
4.8.1. What it is
4.8.2. What you have to do to use it
4.8.3. Related Links
5. OpenLink ODBC Driver (Single-Tier Edition) Configuration
5.1. Windows Data Source Configuration
5.1.1. Creating ODBC Data Sources
5.1.2. DB2
5.1.3. Informix 7 and 9
5.1.4. Ingres and OpenIngres
5.1.5. Oracle 8, 9, and 10
5.1.6. Progress 9.1 SQL-92
5.1.7. Other Progress
5.1.8. Microsoft or Sybase SQL Server (TDS)
5.1.9. ODBC-JDBC Lite Bridges for Java
5.1.10. MySQL
5.1.11. PostgreSQL
5.1.12. Connect String parameters
5.1.13. Testing the ODBC Data Source
5.2. Unix Data Source Configuration
5.2.1. Creating Data Sources Using iODBC Administrator
5.2.2. Manual Configuration
5.2.3. DB2
5.2.4. Informix
5.2.5. Ingres
5.2.6. Oracle
5.2.7. PostgreSQL
5.2.8. MySQL
5.2.9. Progress SQL92
5.2.10. Microsoft or Sybase SQL Server (TDS)
5.2.11. ODBC-JDBC Bridges for Java
5.3. Mac OS X Data Source Configuration
5.3.1. Creating ODBC Data Sources
5.3.2. MySQL
5.3.3. Oracle 8 (or 9)
5.3.4. PostgreSQL
5.3.5. ODBC-JDBC Lite Bridges for Java
5.3.6. Microsoft or Sybase SQL Server (TDS)
5.3.7. Virtuoso
5.3.8. Testing the ODBC Data Source
5.4. ODBC to Jet Data Type Mapping
5.4.1. Overview
5.4.2. ODBC to Jet Data Type Mapping
5.4.3. Jet Data Type Ranges
5.4.4. References
5.4.5. Informix Jet Support
5.4.6. Oracle Jet Support
5.5. New Features
5.6. Oracle Connection Pooling Support
5.6.1. What it is
5.6.2. Benefits
5.6.3. How it Works
5.6.4. The OpenLink Perspective: what you do to use it
5.6.5.
6. OpenLink ADO.NET Data Providers
6.1. Architecture
6.1.1. Managed Data Provider
6.1.2. Unmanaged Data Provider
6.2. Developing .NET Data Provider Application
6.3. OpenLink .NET Data Providers Connect String Attributes
6.3.1. Managed Generic Multi-Tier .NET Data Provider (OpenLink.Data.GenericClient)
6.3.2. Managed Microsoft SQLServer .NET Data Provider (OpenLink.Data.SQLServer)
6.3.3. Managed Sybase .NET Data Provider (OpenLink.Data.Sybase)
6.3.4. Unmanaged .NET Data Provider (OpenLink.Data.OdbcClient)
6.4. OpenLink .NET Data Providers Class Implementation
6.5. OpenLink.Data Namespace
6.5.1. OPLCommand
6.5.2. OPLCommandBuilder
6.5.3. OPLConnect
6.5.4. OPLDataAdapter
6.5.5. OPLDataReader
6.5.6. OPLError
6.5.7. OPLErrorCollection
6.5.8. OPLException
6.5.9. OPLParameter
6.5.10. OPLParameterCollection
6.5.11. OPLRowUpdatedEventArgs
6.5.12. OPLRowUpdatedEventHandler
6.5.13. OPLRowUpdatingEventArgs
6.5.14. OPLRowUpdatingEventHandler
6.5.15. OPLTransaction
6.6. Known Issues
6.6.1. Unsigned Type Handling
6.6.2. Timestamp Precision
6.7. .Net Provider Test Program
6.8. New Features
7. OpenLink OLE-DB Provider
7.1. Testing an OLEDB Connection
7.2. Call Tracing
7.3. Provider Specific Connection Information
7.3.1. Using a Consumer Supplied Prompting Interface
7.3.2. Using a Connection String
7.3.3. Using The DBPROP_INIT_PROVIDERSTRING Property
7.4. Controlling ODBC Cursor Library Usage
7.5. Controlling the Default Bookmark Setting for Rowsets
7.6. Known Issues
7.6.1. General Issues
7.6.2. .Net
7.6.3. Visual Interdev 6
7.6.4. Visual Basic 6 and ADO
7.6.5. SQL Server Data Transformation Services
7.7. Objects and Interfaces Implemented by the OpenLink Provider
7.7.1. Invoking the OpenLink Provider
7.7.2. Connecting from ADO or .Net
7.7.3. Initialization Properties
7.7.4. Initializing and Uninitializing the Data Source Object
7.7.5. Creating a Session
7.7.6. Creating a Rowset
7.7.7. Exposing Metadata
7.7.8. Supported Conversions
7.7.9. Creating and Using Accessors
7.7.10. Rowset MetaData
8. OpenLink JDBC Driver (Single-Tier Edition)
8.1. OpenLink JDBC Driver (Single-Tier Edition) for Java Database Connectivity (JDBC)
8.1.1. New JDBC Driver Packages
8.1.2. New Features & Enhancements
8.2. Downloading Driver Software
8.2.1. OpenLink Web Download Wizard Interaction for obtaining OpenLink Drivers for JDBC Bundle
8.2.2. Download Wizard Interaction for obtaining OpenLink Megathin Drivers for JDBC
8.3. OpenLink JDBC Driver (Single-Tier Lite Edition) Configuration
8.4. OpenLink JDBC Driver (Single-Tier Edition) for JDBC Utilization
8.4.1. OpenLink Driver for JDBC Type 1
8.4.2. OpenLink Driver for JDBC Type 2
8.4.3. OpenLink Driver for JDBC Type 3
8.4.4. Examples
8.5. OpenLink JDBC Driver (Single-Tier Edition) Demonstration Programs
8.5.1. JDBC Compliant Applet Demos
8.5.2. JDBCDemo
8.5.3. ScrollDemo
8.5.4. ScrollDemo2
8.5.5. RowSetDemo
8.5.6. JDBC compliant Application Demos
8.6. OpenLink JDBC Driver (Single-Tier Edition) Important Multi-User JDBC Solution Development & Utilization Issues
8.6.1. Sensitivity To Changes In Underlying Database
8.6.2. Concurrency Control
9. Distributed Transaction Processing (XA)
9.1. Distributed Transaction Processing (DTP)
9.1.1. X/Open DTP Model
9.1.2. OpenLink Resource Manager XA Interface Implementation
9.1.3. Configuring Databases for XA support
9.1.4. OpenLink XA Connection String Formats
9.1.5. Tracing XA calls in OpenLink ODBC Drivers
9.1.6. Enabling XA Transactions on Windows XP SP2 and Windows Server 2003
9.1.7. Using OpenLink Drivers with Tuxedo on Unix
10. OpenLink ODBC Driver (Single-Tier Edition) Unicode Support
10.1. Database Configuration for Unicode
10.1.1. Oracle 8 & 9
10.1.2. Informix 9.x
10.1.3. Sybase 12.5 +
10.1.4. Progress 9.1 (SQL-92)
10.1.5. DB/2 v7.x
10.1.6. MS SQLServer 2000
10.1.7. Operational Notes
11. OpenLink ODBC Driver Manager (iODBC SDK)
11.1. iODBC SDK on Unix
11.2. Configuring Data Sources
11.2.1. The Configuration Files
11.2.2. Making a Test Connection
11.2.3. Compiling Sample Program
11.2.4. Developing ODBC Applications
11.2.5. Further Reading:
11.3. Linking iODBC and ODBC Applications on Mac OS
11.3.1. Mac OS Classic
11.3.2. Mac OS X
11.3.3. References
11.3.4. Porting Mac OS Classic ODBC applications to Mac OS X
12. Bugs Fixed