Properties of Data Sources
Property |
Property |
Description |
Data Source Name |
<data_source_name> |
Name of the data source You can choose any name you like.
The name may not contain any special characters. |
Description |
- |
Description of the data source |
Database |
ServerDB |
Database name |
Server |
ServerNode |
Name of the database computer
If the MaxDB database instance is on the same computer as the ODBC application, you can omit this entry. |
SQLMode |
SQLMode |
|
Isolation Level |
IsolationLevel
|
Lock behavior Concepts of the Database System, Isolation Level |
Trace On
|
TraceFileName |
To activate the ODBC trace for the database instance, choose this property and enter the path and name of the file in which you want the database system to log SQL statements.
This ODBC trace is not to be confused with the driver manager log (tracing) of the Microsoft ODBC Data Source Administrator. The next time you log on to the database instance, the database instance logs all SQL statements sent to the database instance by the application, including the following information: ● Execution time ● CONNECT parameters ● Input and output parameters ● Start and end of the database session
If the ODBC trace is on, the system performs numerous file operations. This can affect the execution speed of the application. Therefore, switch the ODBC trace off as soon as the actions you wish to analyze with the ODBC trace have been executed. |