14. HiRDB Access from ODBC Application Programs

This chapter explains the OBDC driver installation procedure, ODBC functions, and tuning and troubleshooting procedures that are necessary when ODBC application programs access HiRDB.

The ODBC2.0 driver has become obsolete. It is currently supported in order to maintain compatibility with applications, but this support will be discontinued in the future. Please use the ODBC 3.5 driver.

Organization of this chapter

14.1 ODBC application programs

14.2 Installing the ODBC2.0 driver

14.3 Installing the ODBC 3.5 driver and setting the environment variables

14.4 ODBC functions provided by HiRDB

14.5 ODBC function data types and HiRDB data types

14.6 Specifiability of attributes in the ODBC functions

14.7 Asynchronous execution of ODBC functions

14.8 Setting cursor libraries

14.9 File DSNs

14.10 Executing a UAP in Unicode

14.11 Tuning and troubleshooting

14.12 Facilities that cannot be used when HiRDB is accessed with ODBC

14.13 Notes about using the Linux edition of the HiRDB ODBC 3.5 driver

14.14 Automatic SQL statement generation by using .NET Framework Data Provider for ODBC