mkleehammer/pyodbc

How to surface azure active directory service principal related errors

Closed this issue · 3 comments

prdpsvs commented

Environment

  • Python: 3.11.9
  • pyodbc: 5.1.0
  • OS: Ubuntu 22.04 LTS
  • DB: Microsoft Fabric Data Warehouse
  • driver: ODBC Driver 18 for SQL Server

Issue

I am using Azure Service Principal Authentication with pyodbc. what is the best way to surface issue when user provides incorrect client id or secret. Right now, any error during connection is throwing ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

I tried to capture errors from azure identity SDK using from azure.core.exceptions import ClientAuthenticationError, HttpResponseError
but no luck. Any thoughts?

v-chojas commented

The driver returns several diag recs; do you see those in the ODBC trace?

prdpsvs commented

I would like to capture these at the connection failure time programmatically and appropriately surface user-friendly messages. Any specific options to figure out?

v-chojas commented

I am asking if you see all the diag recs in the ODBC trace.