OpenLink ODBC Driver (Lite Edition) Documentation


Table of Contents

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