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.
GaussDB supports ODBC in the following environments.
| OS | Platform |
|---|---|
| EulerOS 2.5 | x86_64 |
| EulerOS 2.9 | Arm64 |
| EulerOS 2.10 | x86_64 |
| EulerOS 2.10 | Arm64 |
| Windows 7 | x86_32 |
| Windows 7 | x86_64 |
| Windows Server 2008 | x86_32 |
| Windows Server 2008 | x86_64 |
| Kylin V10 | x86_64 |
| Kylin V10 | Arm64 |
| UnionTech V20 | x86_64 |
| UnionTech V20 | 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 .
The current database ODBC driver is based on an open-source version and may be incompatible with data types tinyint, smalldatetime, nvarchar, and nvarchar2.
