CHANGEBIGINTDEFAULT specifies the default ODBC mapping used for Adaptive Server bigint columns.
When you use a column of type bigint as an identifier in an Adaptive Server table (for example, as an identity or primary key), and applications such as Microsoft Access access the table through Adaptive Server ODBC Driver, the values of such column may appear as “#deleted”, and prevent further operations on the table. As a workaround, set CHANGEBIGINTDEFAULT to 1.
CHANGEBIGINTDEFAULT values:
0 – the default value, binds SQL_C_DEFAULT to SQL_C_BIGINT.
1 – binds SQL_C_DEFAULT to SQL_C_CHAR. Use this setting when you want to access Adaptive Server tables with bigint identifiers from applications such as Microsoft Access or Microsoft Excel.
2 – binds SQL_C_DEFAULT to SQL_C_WCHAR.