Updated on 2023-10-23 GMT+08:00

Development Based on ODBC

Open Database Connectivity (ODBC) is a Microsoft API for accessing databases based on the X/OPEN CLI. Applications interact with the database through the APIs provided by ODBC, which enhances their portability, scalability, and maintainability.

Figure 1 shows the system structure of ODBC.

Figure 1 ODBC system structure

GaussDB supports ODBC in the following environments.

Table 1 OSs Supported by ODBC

OS

Platform

CentOS 6.4/6.5/6.6/6.7/6.8/6.9/7.0/7.1/7.2/7.3/7.4

x86_64

CentOS 7.6

ARM64

EulerOS 2.0 SP2/SP3

x86_64

EulerOS 2.0 SP8

ARM64

Kylin V10

x86_64

Kylin V10

ARM64

The ODBC Driver Manager running on UNIX or Linux can be unixODBC or iODBC. unixODBC-2.3.7 is used as the component for connecting to the database.

Windows has a native ODBC Driver Manager. You can locate Data Sources (ODBC) by choosing Control Panel > Administrative Tools.

The current database ODBC driver is based on an open-source version and may be incompatible with data types tinyint, smalldatetime, nvarchar, and nvarchar2.