oca_info - 1 The Oracle Open Client Adapter for ODBC (OCA)...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 The Oracle Open Client Adapter for ODBC (OCA) allows Forms Developer and Reports Developer on Microsoft Windows 95 and Windows NT to access ODBC-compliant data sources through ODBC drivers. Using the Oracle Open Client Adapter, an application can access different data sources in a consistent manner. This allows an application developer to build an application that can run unmodified against one of several databases. Alternatively, the application can be targeted at a specific database, and take advantage of features particular to that system. This document explains how to build Forms Developer and Reports Developer applications that access data stored in ODBC data sources. The first chapter, Getting Started, gives general guidelines that apply to any ODBC data source. The second chapter, "Building Oracle Forms Developer and Oracle Reports Developer Applications for ODBC Data Sources", gives instructions for building applications that can access any ODBC data source. For additional information about specific ODBC data sources please refer to the database-specific information chapters. The absence of a specific chapter for a given database does not mean we do not support ODBC access of that database using the OCA. There are a limited number of databases we can test and document, but the OCA should work with any ODBC data source, provided the ODBC driver is compliant with ODBC version 2.0 or above. This document is meant to assist you in using the Oracle Open Client Adapter. The document is divided into chapters on certain areas, but you should be able to start using the OCA just by reading the first two chapters: "Getting Started" and "Building Oracle Forms Developer and Oracle Reports Developer Applications for ODBC Data Sources". Using Oracle® Forms Developer, Oracle® Reports Developer and the Oracle Open Client Adapter to access ODBC Data sources Overview How To Use This Document 2 Several issues concerning usage of the OCA are discussed in the appendices of this document because they deal with situations many users will not meet. 3 Table of Contents 1. GETTING STARTED................................................................................................................ 6 1.1 SUPPORTED DATA SOURCES AND ODBC COMPLIANCE.............................................................. 6 1.2 INSTALLATION, SETUP AND SYSTEM REQUIREMENTS ................................................................ 6 1.3 CONNECTING TO AN ODBC DATA SOURCE..............................................................................10 2. BUILDING ORACLE FORMS DEVELOPER AND ORACLE REPORTS DEVELOPER APPLICATIONS FOR ODBC DATA SOURCES.......................................................................12 2.1 OVERVIEW.............................................................................................................................12 2.2 USING SQL PLUS WITH OCA CONNECTIONS ...........................................................................12 2.3 WRITING PL/SQL FOR USE WITH OCA (ODBC) CONNECTIONS................................................152....
View Full Document

Page1 / 101

oca_info - 1 The Oracle Open Client Adapter for ODBC (OCA)...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online