Welcome to the Progress DataDirect for ODBC Oracle Wire Protocol Driver: Version 8.0.2
What's New in this Release?
Conventions Used in This Guide
About the Product Documentation
Contacting Technical Support
Getting Started
Configuring and Connecting on Windows
Configuring a Data Source
Testing the Connection
Configuring and Connecting on UNIX and Linux
Environment Configuration
Test Loading the Driver
Configuring a Data Source in the System Information File
Testing the Connection
Configuring and Connecting on macOS
iODBC Driver Manager
Configuring a Data Source
Testing the Connection
Accessing Data With Third-Party Applications
What Is ODBC?
How Does It Work?
Why Do Application Developers Need ODBC?
About the Oracle Wire Protocol Driver
Driver Requirements
ODBC Compliance
Support for Multiple Environments
Support for Windows Environments
32-Bit Driver Requirements for Windows
64-Bit Driver Requirements for Windows
Setup of the Driver
Driver File Names for Windows
Support for UNIX and Linux Environments
32-Bit Driver Requirements for UNIX/Linux
64-Bit Drivers Requirements for UNIX/Linux
AIX
HP-UX 11 aCC
Linux
Oracle Solaris
Setup of the Environment and the Drivers
Driver File Names for UNIX/Linux
Support for macOS Environments
32-Bit Driver Requirements for macOS
64-bit Driver Requirements for macOS
Setup of the Environment and the Driver
Driver Names for macOS
Version String Information
getFileVersionString Function
Data Types
XMLType
Examples
Retrieving Data Type Information
Isolation and Lock Levels Supported
Using Parameter Arrays
Supported Features
Unicode Support
Using IP Addresses
Number of Connections and Statements Supported
Support for Oracle RAC
SQL Support
MTS Support
OS Authentication
Stored Procedure Results
Support of Materialized Views
Using the Driver
Configuring and Connecting to Data Sources
Configuring the Product on UNIX/Linux
Environment Variables
Library Search Path
ODBCINI
ODBCINST
DD_INSTALLDIR
Data Source Configuration on UNIX/Linux
Configuring a Data Source in the System Information File
Sample Default odbc.ini File
The Example Application
DSN-less Connections
Sample odbcinst.ini File
File Data Sources
UTF-16 Applications on UNIX and Linux
Configuring the Product on macOS
Installing the Driver Manager for macOS
The Test Loading Tool
Data Source Configuration on macOS
Configuration Through the System Information (odbc.ini) File
Sample Default odbc.ini File
Data Source Configuration through a GUI (macOS)
Tracing Using the iODBC Data Source Administrator
The example Application
DSN-less Connections
Sample odbcinst.ini File
File Data Sources
Supported Character Encoding for macOS Applications
Environment Variables
ODBCINST
Data Source Configuration on Windows
Advanced Tab
Security Tab
Performance Tab
Failover Tab
Pooling Tab
Bulk tab
Client Monitoring Tab
Advanced Security Tab
Proxy Tab
Using a Connection String
Using a Logon Dialog Box
Performance Considerations
Using LDAP
Connecting through a proxy server
Oracle Connection Manager
Unexpected Characters
Using Failover
Connection Failover
Extended Connection Failover
Select Connection Failover
Guidelines for Primary and Alternate Servers
Using Client Load Balancing
Using Connection Retry
Configuring Failover-Related Options
A Connection String Example
An odbc.ini File Example
Using Client Information
How Databases Store Client Information
Storing Client Information
Using Security
Authentication
Kerberos Requirements
Kerberos Authentication
OS Authentication
Oracle Internet Directory (OID)
Oracle Wallet SSL Authentication
Oracle Wallet Password Store
Data Encryption Across the Network
Data Encryption and Integrity
SSL Encryption
Certificates
SSL Server Authentication
SSL Client Authentication
Designating an OpenSSL Library
Using Oracle Wallet as a Keystore
Oracle Advanced Security
Summary of Security-Related Options
Using DataDirect Connection Pooling
Creating a Connection Pool
Adding Connections to a Pool
Removing Connections from a Pool
Handling Dead Connections in a Pool
Connection Pool Statistics
Summary of Pooling-Related Options
Using DataDirect Bulk Load
Bulk Export and Load Methods
Exporting Data from a Database
Bulk Loading to a Database
The Bulk Load Configuration File
Bulk Load Configuration File Schema for Oracle
Verification of the Bulk Load Configuration File
Sample Applications
Character Set Conversions
External Overflow Files
Limitations
Summary of Related Options for DataDirect Bulk Load
Using Bulk Load for Batch Inserts
Determining the Bulk Load Protocol
Limitations
Summary of Related Options for Bulk Load for Batch Inserts
Persisting a Result Set as an XML Data File
Using the Windows XML Persistence Demo Tool
Using the UNIX/Linux XML Persistence Demo Tool
Troubleshooting
Diagnostic Tools
ODBC Trace
Creating a Trace Log
Enabling Tracing
Windows ODBC Administrator
macOS iODBC Administrator
System Information (odbc.ini) File
The Test Loading Tool
ODBC Test
iODBC Demo and iODBC Test
The Example Application
Other Tools
Error Messages
Troubleshooting
Setup/Connection Issues
Troubleshooting the Issue
Interoperability Issues
Troubleshooting the Issue
Performance Issues
Connection Option Descriptions
Accounting Info
Action
AllowedOpenSSLVersions
Alternate Servers
Application Name
Application Using Threads
Array Size
Authentication Method
Batch Size
Bulk Binary Threshold
Bulk Character Threshold
Bulk Options
Cached Cursor Limit
Cached Description Limit
Catalog Functions Include Synonyms
Catalog Options
Client Host Name
Client ID
Client User
Connection Pooling
Connection Reset
Connection Retry Count
Connection Retry Delay
Credentials Wallet Entry
Credentials Wallet Path
Crypto Protocol Version
CryptoLibName
Data Integrity Level
Data Integrity Types
Data Source Name
Default Buffer Size for Long/LOB Columns (in Kb)
Describe at Prepare
Description
Edition Name
Enable Bulk Load
Enable N-CHAR Support
Enable Scrollable Cursors
Enable Server Result Cache
Enable SQLDescribeParam
Enable Static Cursors for Long Data
Enable Timestamp with Timezone
Encryption Level
Encryption Method
Encryption Types
Failover Granularity
Failover Mode
Failover Preconnect
Fetch TSWTZ as Timestamp
Field Delimiter
GSS Client Library
Host
Host Name In Certificate
IANAAppCodePage
Impersonate User
Initialization String
Key Password
Key Store
Key Store Password
LDAP Distinguished Name
Load Balancing
LoadBalance Timeout
LOB Prefetch Size
Local Timezone Offset
Lock Timeout
Login Timeout
Max Pool Size
Min Pool Size
Module
Password
Port Number
Proxy Host
Proxy Mode
Proxy Password
Proxy Port
Proxy User
PRNGSeedFile
PRNGSeedSource
Procedure Returns Results
Program ID
Query Timeout
Record Delimiter
Report Codepage Conversion Errors
Report Recycle Bin
SDU Size
Server Name
Server Process Type
Service Name
SID
SSLLibName
Support Binary XML
TCP Keep Alive
Timestamp Escape Mapping
TNSNames File
Trust Store
Trust Store Password
Use Current Schema for SQLProcedures
User Name
Validate Server Certificate
Wallet Password
Wire Protocol Mode
Reference
Code Page Values
IANAAppCodePage Values
ODBC API and Scalar Functions
API Functions
Scalar Functions
String Functions
Numeric Functions
Date and Time Functions
System Functions
Internationalization, Localization, and Unicode
Internationalization and Localization
Locale
Language
Country
Variant
Unicode Character Encoding
Background
Unicode Support in Databases
Unicode Support in ODBC
Unicode and Non-Unicode ODBC Drivers
Function Calls
Unicode Application with a Non-Unicode Driver
Unicode Application with a Unicode Driver
Data
Unicode Driver
ANSI Driver
Default Unicode Mapping
Connection Attribute for Unicode
Driver Manager and Unicode Encoding on UNIX/Linux
References
Character Encoding in the odbc.ini and odbcinst.ini Files
Designing ODBC Applications for Performance Optimization
Using Catalog Functions
Caching Information to Minimize the Use of Catalog Functions
Avoiding Search Patterns
Using a Dummy Query to Determine Table Characteristics
Retrieving Data
Retrieving Long Data
Reducing the Size of Data Retrieved
Using Bound Columns
Using SQLExtendedFetch Instead of SQLFetch
Choosing the Right Data Type
Selecting ODBC Functions
Using SQLPrepare/SQLExecute and SQLExecDirect
Using Arrays of Parameters
Using the Cursor Library
Managing Connections and Updates
Managing Connections
Managing Commits in Transactions
Choosing the Right Transaction Model
Using Positioned Updates and Deletes
Using SQLSpecialColumns
Using Indexes
Introduction
Improving Row Selection Performance
Indexing Multiple Fields
Deciding Which Indexes to Create
Improving Join Performance
Locking and Isolation Levels
Locking
Isolation Levels
Locking Modes and Levels
SSL Encryption Cipher Suites
DataDirect Bulk Load
DataDirect Bulk Load Functions
Utility Functions
GetBulkDiagRec and GetBulkDiagRecW
Export, Validate, and Load Functions
ExportTableToFile and ExportTableToFileW
ValidateTableFromFile and ValidateTableFromFileW
LoadTableFromFile and LoadTableFromFileW
DataDirect Bulk Load Statement Attributes
SQL_BULK_EXPORT
SQL_BULK_EXPORT_PARAMS
Threading
WorkAround Options
Glossary
application
authentication
bulk load
client load balancing
conformance
connection pooling
connection retry
connection string
data source
driver
Driver Manager
DSN (Data Source Name)
DTC (Distributed Transaction Coordinator)
failover
index
isolation level
Kerberos
load balancing
locking level
MTS (Microsoft Transaction Server)
NTLM
ODBC Administrator
OS authentication
Performance Tuning Wizard
reauthentication
SQL Grammar
Secure Sockets Layer (SSL)
SSL client/server authentication
Unicode
user ID/password authentication
Copyright
Welcome to the Progress DataDirect for ODBC Oracle Wire Protocol Driver: Version 8.0.2
Copyright
orawpgeneral
orawpadvanced
orawpsecurity
orawpperform
orawpfail
orawpcpool
orawpbulk
orawpclientmon
orawpadvsecurity
orawpproxy
orawplogon