Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for ODBC Drivers Reference March 2026

Troubleshooting

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for ODBC Drivers Reference
    • What is ODBC?
      • How does it work?
      • Why do application developers need ODBC?
  • Troubleshooting
    • Diagnostic tools
      • ODBC trace
        • Creating a trace Log
        • Enabling tracing
          • Windows ODBC Administrator
          • System information (odbc.ini) file
      • Configuration Manager Portal trace
      • Packet logging
      • Test loading tool
      • ODBC Test
      • Logging for Java components
        • Loggers and logging levels
          • Driver to SQL communication logger
          • SQL engine logger
          • Wire protocol adapter logger
        • Configuring logging
          • Using the JVM
          • Using the driver
      • The demoodbc Application
      • The example application
      • Enabling debug record mode
      • Other tools
    • Error messages
    • Troubleshooting issues
      • Setup/connection issues
        • Troubleshooting the issue
      • Interoperability issues
        • Troubleshooting the issue
      • Performance issues
  • Failover
    • Connection failover
    • Extended connection failover
    • Select connection failover
    • Guidelines for primary and alternate servers
    • Using client load balancing
    • Using connection retry
    • Summary of failover-related options
      • A connection string example
      • An odbc.ini file example
  • Client information
    • How databases store client information
    • Storing client information
  • Code page values
    • IANAAppCodePage values
    • IBM to IANA code page values
    • Teradata code page 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
  • Security best practices for ODBC applications
    • Secure connection option settings
    • Protect data buffered to disk
    • Encrypt transferred data
    • Secure your driver configuration
    • Use advanced authentication methods
    • Protect against SQL injection attacks
    • Use HTTP proxies
    • Secure log files
    • Security considerations for the SQL engine server
  • 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
      • Using the TableName parameter with the Salesforce driver
      • SetBulkOperation (Salesforce driver only)
      • GetBulkOperation (Salesforce driver only)
    • DataDirect Bulk Load statement attributes
      • SQL_BULK_EXPORT_PARAMS
      • SQL_BULK_EXPORT
  • 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
  • Threading
  • WorkAround options
  • Copyright
Table of Contents

Troubleshooting

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: August 19, 2019
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Aha! 8.0
    • Amazon Redshift 8.0
    • Apache Cassandra 8.0
    • Apache Hive 8.0
    • Apache Spark SQL 8.0
    • Autonomous Rest Connector 8.0
    • Cloudera Impala 7.1
    • dBase 7.1
    • + 24
      • Flat files/Text 7.1
      • GitHub 8.0
      • Google Bigquery 8.0
      • HubSpot 8.0
      • IBM Db2 8.0
      • IBM Informix Wire Protocol 8.0
      • Microsoft Dynamics 365 8.0
      • Microsoft SharePoint 8.0
      • Microsoft SQL Server 8.0
      • MongoDB 8.0
      • MySQL 8.0
      • MySQL 7.1
      • Oracle Database Wire Protocol 8.0
      • Oracle Service Cloud 7.1
      • Pervasive (Btrieve) 7.1
      • Greenplum 8.0
      • PostgreSQL 8.0
      • Progress Openedge 8.0
      • Salesforce 8.0
      • SAP S/4HANA 8.0
      • Snowflake 8.0
      • Teamcity 8.0
      • XML 7.1
      • Documentation

This part guides you through troubleshooting Progress DataDirect for ODBC drivers. It provides you with solutions to common problems and documents error messages that you may receive.

Contents
  • Diagnostic tools
  • Error messages
  • Troubleshooting issues
TitleResults for “How to create a CRG?”Also Available inAlert