EDB Postgres™ Advanced Server ODBC Connector Guide

ODBC (Open Database Connectivity) is a programming interface that allows a client application to connect to any database that provides an ODBC driver. EDB-ODBC provides connectivity between EDB Postgres Advanced Server (Advanced Server) and ODBC-compliant applications.

This guide contains installation information for EDB-ODBC as well as information about creating data source definitions for EDB-ODBC. This guide also contains reference information that details the ODBC functionality supported by EDB-ODBC.

• What’s New
• Requirements Overview
  • Supported Versions
  • Supported Platforms
• EDB-ODBC Overview
  • Installing EDB-ODBC
    • Installing the Connector with an RPM Package
    • Installing the Connector on an SLES 12 Host
    • Installing a DEB Package on a Debian or Ubuntu Host
    • Using the Graphical Installer to Install the Connector
• Creating a Data Source
• EDB-ODBC Connection Properties
  • Adding a Data Source Definition in Windows
  • Adding a Data Source Definition in Linux
• EDB-ODBC Driver Functionality
  • SQLGetInfo()
  • Connection Attributes
    • SQLGetConnectAttr()
    • SQLSetConnectAttr()
  • Environment Attributes
    • SQLGetEnvAttr()
    • SQLSetEnvAttr()
  • Statement Attributes
    • SQLGetStmtAttr()
    • SQLSetStmtAttr()
  • Error Handling
    • SQLGetDiagRec()
  • Supported ODBC API Functions
  • Supported Data Types
  • Thread Safety
• Security and Encryption
  • Scram Compatibility
• Conclusion