What is HCL OneDB ODBC Driver?

Open Database Connectivity (ODBC) is a specification for a database application programming interface (API).

Microsoft™ ODBC, Version 3.0, is based on the Call Level Interface specifications from X/Open and the International Standards Organization/International Electromechanical Commission (ISO/IEC). ODBC supports SQL statements with a library of C functions. An application calls these functions to implement ODBC functionality.

ODBC applications enable you to perform the following operations:

Connect to and disconnect from data sources
Retrieve information about data sources
Retrieve information about HCL® OneDB® ODBC Driver
Set and retrieve HCL OneDB ODBC Driver options
Prepare and send SQL statements
Retrieve SQL results and process the results dynamically
Retrieve information about SQL results and process the information dynamically

ODBC lets you allocate storage for results before or after the results are available. This feature lets you determine the results and the action to take without the limitations that predefined data structures impose.

ODBC does not require a preprocessor to compile an application program.

ODBC supports Secure Sockets Layer (SSL) connections. For information about using the SSL protocol, see Secure sockets layer protocol.