HP Integrity NonStop H-Series - Manual (Page 34)

Windows
To add a new data source or configure an existing data source, see “Configuring a client data
source” .
Perform the following steps to delete a client data source:
1.
Select Start -> Control Panel -> Administrative Tools -> Data Sources
(ODBC)
.
2. Click either the System DSN or the User DSN tab to get the list of data sources.
3. Select the data source name that you want to delete and click Remove.
4. Click Yes in the confirmation dialog box to remove the data source.
Managing transactions
The AutoCommit property indicates whether SQL/MX must automatically commit the transaction
or not.
nl The following are the valid values for AutoCommit property:
•
ON
•
OFF
•
SERVER_DEFAULT specifies to use the server side AutoCommit settings. This option is useful
for existing applications where AutoCommit is set on the server side data source and the
user wants to persist with the same settings without making any changes to the client application
or client side data source. This is the default option.
AutoCommit property can be set in the following ways:
•
Using SQLSetConnectAttr API, the values are ON/OFF.
•
Using DSN properties, the values are SERVER_DEFAULT/ON/OFF.
•
Using connection string without DSN, the values are ON/OFF/SERVER_DEFAULT.
NOTE: The value set using SQLSetConnectAttr API takes the highest precedence.
Setting AutoCommit
Windows driver
You can set the AutoCommit property from the Data Access tab.
Unix drivers
AUTOCOMMIT (case sensitive) is the keyword to set AutoCommit property in property file
(MXODSN for Linux and HP-UX, ODBCDSN for OSS).
Example 1 Depicting AUTOCOMMIT set to SERVER_DEFAULT
[TDM_Default_DataSource]
Description = Default Data Source
Catalog = CAT
Schema = SCH
DataLang = 0
FetchBufferSize = SYSTEM_DEFAULT
Server = TCP:hostname/portnumber
SQL_ATTR_CONNECTION_TIMEOUT = SYSTEM_DEFAULT
SQL_LOGIN_TIMEOUT = SYSTEM_DEFAULT
SQL_QUERY_TIMEOUT = NO_TIMEOUT
SQLFractionValue = SYSTEM_DEFAULT
SQLDatetimeRetrieval = MSDN_DEFAULT
AUTOCOMMIT = SERVER_DEFAULT
34 Configuring data sources