Book Home

Contents
Preface

Overview
New Features in OpenLink UDA
System Requirements and Basic Instructions
Installation Guide
ODBC Drivers
ADO.NET Data Providers
OLE-DB Client Provider
JDBC Drivers
Distributed Transaction Processing (XA)
Unicode Support
iODBC Driver Manager SDK
Bugs Fixed

OpenLink Lite Documentation - Contents

1. Overview
1.1. Introduction to ODBC
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. 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. Installation Guide
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.7. Oracle Connection Pooling Support
4.7.1. What it is
4.7.2. Benefits
4.7.3. How it Works
4.7.4. The OpenLink Perspective: what you do to use it
4.8. Oracle 10g Instant Client: Connection String Formats
4.8.1. OpenLink Single-Tier Connections using Instant Client
4.8.2. Oracle Instant Client Related Links
4.9. Oracle Real Application Cluster (RAC) / TAF Support
4.9.1. What it is
4.9.2. What you have to do to use it
4.9.3. Related Links
5. ODBC Drivers
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
6. 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. OLE-DB Client 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.2. Invoking the OpenLink Provider
7.7.3. Connecting from ADO or .Net
7.7.4. Initialization Properties
7.7.5. Initializing and Uninitializing the Data Source Object
7.7.6. Creating a Session
7.7.7. Creating a Rowset
7.7.8. Exposing Metadata
7.7.9. Supported Conversions
7.7.10. Creating and Using Accessors
7.7.11. Rowset MetaData
8. JDBC Drivers
8.1. OpenLink Drivers 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. JDBC Lite Configuration
8.4. OpenLink Drivers 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 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. 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)
10. Unicode Support
10.1. Unicode Driver support
10.2. Database Configuration for Unicode
10.2.1. Oracle 8 & 9
10.2.2. Informix 9.x
10.2.3. Sybase 12.5 +
10.2.4. Progress 9.1 (SQL-92)
10.2.5. DB/2 v7.x
10.2.6. MS SQLServer 2000
10.2.7. Operational Notes
11. iODBC Driver Manager SDK
11.1. iODBC SDK on Unix
11.2. Configuring Data Sources
11.2.3. The Configuration Files
11.2.4. Making a Test Connection
11.2.5. Compiling Sample Program
11.2.6. Developing ODBC Applications
11.2.7. 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