Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Related Documents
  • Conventions
• Changes in ODBC Developer’s Guide
  • New Features in 26ai
    • ODBC Release 26ai
  • New Features in Earlier Releases
    • ODBC Release 21c, Version 21.1
    • ODBC Release 19c, Version 19.1.0.0.0
    • ODBC Release 18c, Version 18.1.0.0.0
    • ODBC 12.2.0.1.0
  • Deprecated Features
• Introduction to the Oracle Database ODBC Driver
  • About the ODBC Driver
  • What Is the Oracle Database ODBC Driver
  • Certifications for Oracle Database ODBC Driver on Windows
  • Certifications for Oracle ODBC Driver on UNIX Platforms
  • Driver Conformance Levels
• Getting Started
  • Summary of Steps
  • Installation
    • System Requirements
      • Software Required
      • Server Software Requirements
      • Hardware Required
    • Installing Oracle Instant Client ODBC (Linux and UNIX)
      • Recommended unixODBC Driver Manager Versions for Linux and UNIX
    • Installing Oracle Instant Client ODBC (Windows)
    • Content of the Oracle Instant Client ODBC Package
    • Files Created by the Installation
  • Configuration
    • Environment Setup for ODBC Applications
    • Configuring Oracle Net Services
    • Configuration for UNIX Platforms
      • Usage
    • Configuration for Windows
      • Configuring the Data Source
      • Oracle Database ODBC Driver Configuration Dialog Box
    • Reducing Lock Timeout
  • Patching Oracle Instant Client ODBC
    • Patching Oracle Instant Client ODBC on Linux and UNIX Method 1
    • Patching Oracle Instant Client ODBC on Linux and UNIX Method 2
    • Patching on Windows
  • Uninstallation
    • Uninstalling Oracle Instant Client ODBC on Linux and UNIX
    • Uninstalling Oracle Instant Client ODBC on Windows
• Basic Connection Steps
  • Connecting to an Oracle Data Source
  • Troubleshooting
    • About Using Oracle Database ODBC Driver for the First Time
    • Expired Password
• Using the Oracle Database ODBC Driver
  • Connecting to Oracle Database Using TLS (Preconfigured for Azure AD)
    • Overview
    • Prerequisite Steps to Using Oracle ODBC with Excel
    • Installing the ODBC Driver
    • Configuring tnsnames.ora, TNS_ADMIN, and PATH
    • Getting an OAuth 2 Token
    • Configuring DSN
    • Configuring Excel
  • Creating Oracle Database ODBC Driver TNS Service Names
  • SQL Statements
  • Data Types
  • Implementation of Data Types (Advanced)
  • Error Messages
• Oracle Database ODBC Driver 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 ROWID
  • ROWID 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 Database 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
  • Database Resident Connection Pooling Support
    • Prerequisites
    • Configure DRCP on the Database Server
    • Setting Up Connection Class in Oracle ODBC Driver
    • Enabling ODBC Driver Manager Connection Pooling
      • Enabling ODBC DM Connection Pooling on Linux and UNIX Platforms
      • Enabling ODBC DM Connection Pooling on Windows
• Unsupported Features and Known Issues
  • Unsupported Features
  • Known Limitations
  • Known Software Issues