The new logging feature for ASE OLE DB Provider allows you to track an application’s database access by logging calls to the OLE DB public API.
You enable the logging feature by creating a registry entry that identifies a configuration file. The configuration file is a properties file that allows you to log all calls to OLE DB, or limit logging to a specified subset of the API.
To enable the logging feature
Create a properties file. For example:
### --- Begin oledblog.properties ---
#----------------------------------
#Configure loggers
# by default turn everything off. Change this to "=TRACE, OLEDB_LOGFILE"
# to default to logging to a file
log4cplus.rootLogger=OFF, NULL
# We want to log the OLEDB API calls to a log file
# change this to ="OFF,NULL" if you only want to log certain methods
log4cplus.logger.com.sybase.dataaccess.oledb=TRACE, OLEDB_LOGFILE
log4cplus.additivity.com.sybase.dataaccess.oledb=false
# We don't want to log the IUnknown::AddRef and Release calls
log4cplus.logger.com.sybase.dataaccess.oledb.IUnknown.AddRef=OFF, NULL
log4cplus.additivity.com.sybase.dataaccess.oledb.IUnknown.AddRef=false
log4cplus.logger.com.sybase.dataaccess.oledb.IUnknown.Release=OFF, NULL
log4cplus.additivity.com.sybase.dataaccess.oledb.IUnknown.Release=false
# Other OLEDB interface can be turned on and off as well
# You can turn on (or off) logging of all methods on a given interface
# by configuring:
# log4cplus.logger.com.sybase.dataaccess.oledb.<InterfaceName>=???
# You can get more specific and only log (or turn off logging for) a
# specific method:
log4cplus.logger.com.sybase.dataaccess.oledb.<InterfaceName>.
<MethodName>=TRACE, OLEDB_LOGFILE
#-------------------------------------
#Configure logging appenders
# Throw away all log messages
log4cplus.appender.NULL=log4cplus::NullAppender
# Send log messages to the console
log4cplus.appender.STDOUT=log4cplus::ConsoleAppender
log4cplus.appender.STDOUT.layout=log4cplus::PatternLayout
### Modify this line to define the output format
log4cplus.appender.STDOUT.layout.ConversionPattern=%m%n
# Write the log messages to a file
log4cplus.appender.OLEDB_LOGFILE=log4cplus::FileAppender
log4cplus.appender.OLEDB_LOGFILE.layout=log4cplus::PatternLayout
log4cplus.appender.OLEDB_LOGFILE.ImmediateFlush=true
### Modify this line to define the output format
log4cplus.appender.OLEDB_LOGFILE.layout.ConversionPattern=%m%n
### Modify this line to specify the file to save the log to.
log4cplus.appender.OLEDB_LOGFILE.File=c:\temp\oledb.log
### --- End oledblog.properties ---
For more information on creating a properties file,
refer to the log4cplus project page.
Create a registry entry:
HKEY_CURRENT_USER\Software\Sybase\OLEDB Provider
LogConfigFile=<path to properties file>
Restart the application you want to log. Upon restart, the application begins to log to the log file specified in the properties file.
To disable the logging feature, delete the registry
entry created in Step 2.
