Today, I worked on a service request that our customer asked how to tracing/logging the Microsoft JDBC or ODBC driver operation. In this article, I'm going to show several ways to do it.
- For JDBC, we have standard Java logging: https://docs.microsoft.com/en-us/sql/connect/jdbc/tracing-driver-operation?view=sql-server-ver15
- For ODBC, there is ODBC tracing in Windows: https://docs.microsoft.com/en-us/sql/odbc/admin/setting-tracing-options?view=sql-server-ver15
- And on Linux/macOS: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/data-access-tracing-with-the-odbc-driver-on-linux?view=sql-server-ver15
- Also, in this article you could find a TDSDump for Python with very useful information about it.
Enjoy!
Published Feb 24, 2022
Version 1.0
Jose_Manuel_Jurado
Microsoft
Microsoft