Using connection string without dsn, Tracing – HP Integrity NonStop H-Series User Manual
Page 35
Using connection string without DSN
You can set AUTOCOMMIT as part of the Connection string.
“AutoCommit=ON/OFF/SERVER_DEFAULT”.
Example 2 Depicting AUTOCOMMIT set to ON
Driver={NonStop(TM)ODBCMX 3.2};
ServerDSN = TDM_Default_DataSource;
SERVER =TCP:
UID=
PWD=
AutoCommit=ON;
..,..,.,,.,
NOTE:
For Windows driver, if AutoCommit property is set to OFF without using
SQLSetConnectAttrAPI
, then the application must execute the commit/rollback as a statement
to end an active transaction. SQLEndTrans API cannot be used in this scenario.
Tracing
Unix
You can enable or disable tracing by modifying the TraceStart attribute in MXODSN or
ODBCDSN
file. For more information about tracing options, see
.
NOTE:
If tracing is enabled, the global trace flag is set and from then onwards, all the
traceable ODBC data is logged in the trace file.
Perform the following steps to enable tracing:
1.
Stop the application.
2.
Set the TraceStart attribute to 1 in the MXODSN or ODBCDSN file, and save.
3.
Start the application.
Perform the following steps to disable tracing:
1.
Stop the application.
2.
Set the TraceStart attribute to 0 in the MXODSN or ODBCDSN file, and save.
3.
Start the application.
Windows
Perform the following steps to configure tracing for ANSI or Unicode drivers:
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 and click Configure.
4.
Select the Tracing tab.
5.
Choose NonStop ODBCMX API or Network Layer, or both.
6.
Enter a log file name.
7.
Click Apply and then click OK.
Perform the following steps to start tracing:
1.
Select Start -> Control Panel -> Administrative Tools -> Data Sources
(ODBC)
.
2.
Select the Tracing tab.
3.
Select the Custom Trace DLL. Use the Select DLL button to locate the correct file.
Tracing
35