Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ ODBC Driver GuideThe HCL OneDB™ ODBC Driver Programmer's Manual serves as a user guide and reference for HCL OneDB™ ODBC Driver, which is the HCL OneDB™ implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
Data typesThese topics contain information about the data types that are supported by HCL OneDB™ ODBC Driver.
SQL data typesHCL OneDB™ database server uses SQL data types.
Standard SQL data typesStandard HCL OneDB™ SQL data types have corresponding HCL OneDB™ ODBC Driver data types.
Visual Basic client-side cursorsWhen you use Visual Basic client-side cursors to perform rowset update related operations with using CHAR or LVARCHAR columns that have lengths greater than or equal to 16,385, the HCL OneDB™ ODBC Driver might return an error.

Visual Basic client-side cursors

When you use Visual Basic client-side cursors to perform rowset update related operations with using CHAR or LVARCHAR columns that have lengths greater than or equal to 16,385, the HCL OneDB™ ODBC Driver might return an error.

Visual Basic sends the SQL data type to SQLBindParameter as SQL_LONGVARCHAR instead of SQL_VARCHAR when the length is greater than or equal to 16,385. HCL OneDB ODBC Driver maps SQL_LONGVARCHAR to TEXT data type. Therefore, applications might see the error:

[Informix][Informix ODBC Driver]No cast from text to lvarchar

[Informix][Informix ODBC Driver]Illegal attempt to use Text/Byte host variable.