Specifes the file path to the log file where the provider records its activities, such as authentication, query execution, and connection details.

Data Type

string

Default Value

""

Remarks

This property specifies the location and name of the log file where the server records its operations, including authentication events, query execution, and connection details. If the specified file does not exist, the server creates it. Ensure that the user or the service running the server has write access to the specified path or file. Without sufficient permissions, the log file is not created.

Sensitive information from the connection string, such as passwords and tokens, is automatically masked in the logs. However, sensitive information present in the data itself may not be masked.

If you specify a relative path for Logfile, and if the Location property is set, that directory is used as the base path for the log file.

Additional properties allow you to customize logging behavior:

• Use Verbosity to control the level of detail of the log file.
• Manage log file size with MaxLogFileSize and control the number of retained log files with MaxLogFileCount.
• Filter specific log modules by adjusting the LogModules property.

Java Logging

Logfile=JAVALOG://myloggername

where JAVALOG:// is a required prefix, and myloggername is the name of your logger.

Once Logfile is set appropriately, the supplied Logger's getLogger method is called, using the supplied value to create the Logger instance. If a logging instance already exists, the call references the existing instance.

When Java logging is enabled, Verbosity automatically corresponds to specific logging levels.