Oracle ODBC Driver Help
Release 2 (12.2.0.2.0)
Contents
Using the Oracle ODBC Driver
About Oracle ODBC Driver
For All Users
Oracle ODBC Driver
What Is the Oracle ODBC Driver
New and Changed Features
Features Not Supported
Files Created by the Installation
Driver Conformance Levels
Known Limitations
Configuration Tasks
Configuring Oracle Net Services
Configuring the Data Source
Oracle ODBC Driver Configuration Dialog Box
Modifying the oraodbc.ini File
Reducing Lock Timeout
Connecting to a Data Source
Connecting to an Oracle Data Source
Troubleshooting
Using the Oracle ODBC Driver for the First Time
Expired Password
For Advanced Users
Creating Oracle ODBC Driver TNS Service Names
SQL Statements
Data Types
Implementation of Data Types (Advanced)
Limitations on Data Types
Error Messages
For Programmers
Format of the Connection String
SQLDriverConnect Implementation
Reducing Lock Timeout in a Program
Linking with odbc32.lib (Windows) or libodbc.so (UNIX)
Information About rowids
Rowids in a WHERE Clause
Enabling Result Sets
Enabling EXEC Syntax
Enabling Event Notification for Connection Failures in an Oracle RAC Environment
Using Implicit Results Feature Through ODBC
About Supporting Oracle TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE Column Type in ODBC
About the Effect of Setting ORA_SDTZ in Oracle Clients (OCI, SQL*Plus, Oracle ODBC driver, and Others)
Supported Functionality
API Conformance
Implementation of ODBC API Functions
Implementation of the ODBC SQL Syntax
Implementation of Data Types (Programming)
Unicode Support
Unicode Support Within the ODBC Environment
Unicode Support in ODBC API
Unicode Functions in the Driver Manager
SQLGetData Performance
Unicode Samples
Performance and Tuning
General ODBC Programming Tips
Data Source Configuration Options
DATE and TIMESTAMP Data Types
Documentation Accessibility