Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Troubleshooting : ODBC options : Using MS SQL Server and DataServer options : Logging options
 
Logging options
When connecting to a client with the -Dsrv switch, you can specify logging options. Use logginglevel to define the granularity of your log reports, and use logentrytypes to specify the types of entries to be included in the log. For more information on logging, see Analyzing application execution with Enhanced Logger.
The following example demonstrates the use of the logginglevel parameter:
CONNECT data-source-name -ld logical-name -dt mss
-Dsrv logginglevel,3.
This next example demonstrates the use of the logentrytypes parameter:
CONNECT data-source-name -ld logical-name -dt mss
-Dsrv logentrytypes,SQL:3,Cursor:4,Trans.
In the above example, the Trans log entry type inherits the default logging level of 2 unless the logginglevel -Dsrv switch is also specified as a startup parameter - in which case that logging level would be set generically for all log entry types: SQL, Cursor and Trans.