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
Testing an OLEDB Connection
Call Tracing
Provider Specific Connection Information
Controlling ODBC Cursor Library Usage
Controlling the Default Bookmark Setting for Rowsets
Known Issues
Objects and Interfaces Implemented by the OpenLink 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

Abstract

Table of Contents

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

The OpenLink ODBC Provider for OLEDB is delivered as an OLEDB - ODBC bridge. It utilizes ODBC data sources to connect to databases, much like the Microsoft ODBC Provider; so you will require a working ODBC installation first.

The OpenLink Provider also requires that the Microsoft Data Access Components have been installed. To gain any functionality with .Net you will require MDAC 2.7 RTM (2.70.7713.4) or later. This particular version of the MDAC is included with Visual Studio .Net and with the .Net Framework SDK. Alternatively it can be downloaded from www.microsoft.com/data. Releases prior to 2.70.7713.4, specifically MDAC 2.7 included in the .Net SDK Beta 2, will not allow non-Microsoft OLE DB providers to work with the .Net Data Provider for OLE DB.

Although not completely necessary if you are using a newer OpenLink installer, before installing this provider, any previous release of the driver should be deinstalled fully. If a full deinstall using Install Shield is not performed, the old driver should be unregistered using the regsvr32 utility as follows:

regsvr32 /u oploleod.dll