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.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.