This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.
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!