skip to main content
Using the ODBC Client : Specifying ODBC Connection Attributes : LimitParameterBindSize
 

LimitParameterBindSize

Attribute

LimitParameterBindSize (LPBS)

Configuration

All

Description

Specifies the parameter bind size for SQL_CHAR, SQL_VARCHAR, SQL_BINARY, and SQL_VARBINARY values. When exporting a table from Microsoft Access that contains Null data in a memo column, Microsoft Access binds the parameter with a columnSize of 4294967295. The ODBC Client attempts to allocate a buffer of this size, which typically fails due to lack of memory.
To get around this application bug, the OpenAccess SDK Server can be configured to limit the parameter bind size for SQL_CHAR, SQL_VARCHAR, SQL_BINARY, and SQL_VARBINARY values to a reasonable value.