SQL/MX Connectivity Service Manual (SQL/MX 2.x)

Using Microsoft Access with ODBC/MX
HP NonStop SQL/MX Connectivity Service Manual—524944-008
B-2
SQL_ATTR_ACCESS_MODE for Microsoft Access
SQL_ATTR_MSACCESS_VERSION must be set to 2000 for this mapping to
take effect.
See Reconfiguring Server Data Sources on page 3-4 for details about using
NSM/web to change settings.
•
Using MXCI in MXCS mode, the syntax is:
CS> add evar <dsname>.SQL_ATTR_MAP_DATATYPE,type set,
value ‘BIGINT_TO_NUMERIC’;
•
Setting the SQL_ATTR_MAP_DATATYPE attribute defines this behavior:
•
BIGINT data types are returned as NUMERIC (19,0).
•
UNSIGNED INT columns are returned as NUMERIC (19,0) for ODBC 2.0
applications.
•
Tables imported using the NUMERIC (19,0) data type cannot be exported
again.
SQL_ATTR_ACCESS_MODE for Microsoft Access
You can set access mode on the server by defining this environment variable. If you
are using the SQL_ATTR_MSACCESS_VERSION variable, you do not have to set this
variable.
•
To set the attribute:.
•
In the NSM/web SET tab, the settings are SQL_MODE_READ_WRITE or
SQL_MODE_READ_ONLY.
See Reconfiguring Server Data Sources on page 3-4 for details about using
NSM/web to change settings.
•
To set this attribute using MXCI in MXCS mode, the syntax is:
CS> add evar <dsname>.SQL_ATTR_ACCESS_MODE,type set, value
‘SQL_MODE_READ_WRITE’;
or
CS> add evar <dsname>.SQL_ATTR_ACCESS_MODE,type set, value
‘SQL_MODE_READ_ONLY’;
The default setting is SQL_MODE_READ_WRITE and is overridden by the setting
from ODBC when calling the SQLSetConnectAttr function.
If you have set this variable to SQL_MODE_READ_ONLY and ODBC does not
override the setting, update, insert, and delete statements will fail with an error.