This document describes how to set up various development tools using the ODBC Driver in Altibase development in the Windows environment.
This document is based on Altibase version 6.5.1 and Windows 10.
The ODBC for Windows is provided only up to Altibase version 6.5.1, and not provided to Altibase version 7 or later.
Altibase ODBC Driver Configuration
Before the development, the ODBC Driver provided by Altibase must be installed. This can be downloaded from http://support.altibase.com/en/.
Go to http://support.altibase.com/en/, then "Downloads" → "Products" to download Windows ODBC files for each version. (Supports up to Altibase version 6.5.1)
For older versions that are unable on the website, please contact email@example.com.
Installing ODBC Driver
When installing for the first time, download and install the WINDOWS CLIENT package.
Since there is no complicated process when installing the WINDOW CLIENT package, this document will not describe it separately.
When installing WINDOWS CLIENT, the ODBC installation screen appears as shown below.
ODBC settings in Control Panel
To register Altibase ODBC Driver, click “Start” → “Control Panel” → “Management Tools” → “ODBC Data Source (64-bit)” → “Add”.
After clicking "Add", select ALTIBASE_HDB_ODBC_64bit and click "Finish".
When the following DB connection setting screen appears, enter the setting value for the connection.
|DB Name||DB_NAME created at the time of DB creation||mydb|
|Host (name or IP)||IP information where Altibase DB Server is located||192.168.1.35|
|NLS_USE||DB character set||MS949|
|Password||DB account password||manager|
|Port (default 20300)||Altibase DB Server connection port information||20300|
|User||Account on DB||sys|
|Windows DSN Name||Name that distinguishes it from other DSN names||SERVER1|
If the user clicks the "Test Connection" button after entering each item, the user can check the connection to the Altibase Driver with ODBC Driver. (Altibase DB Server must be running.)
If this is properly set, the user can check the newly added ODBC items as follows.