Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Issues with ODBC Driver 17 for SQL Server on Windows: Connection Tests Pass but Table Sele

Prisco
5 - Atom

Hello,

I'm encountering a peculiar issue with the Microsoft ODBC Driver 17 for SQL Server. While I'm able to connect to my SQL Server instance using Azure Active Directory authentication, and the connection tests pass without issues, I run into errors when I attempt to select a table.

Here are the specifics of my situation:

  1. ODBC Driver Version: I've confirmed that I have version 2017.1710.0003.01 of the ODBC Driver 17 for SQL Server installed, located in C:\Windows\System32, which suggests it's the x64 version.

  2. Connection Details: The connection is successful when testing and within a Python script. However, issues arise when I try to select tables, triggering a SQLDriverConnect error.

  3. Error Messages: When attempting to select a table, the error message "Get Table List Error: Error SQLDriverConnect" appears.

  4. Previous Troubleshooting: I've checked for network-related errors and ensured there are no mismatches in TLS versions or cipher suites. The certificates used by SQL Server for encryption also appear to be up to date.

Could there be a problem with the ODBC driver version, or is this more likely related to Azure AD configurations or permissions?

Any insights or suggestions for further troubleshooting steps would be greatly appreciated.

Thank you!

0 REPLIES 0
Labels
Top Solution Authors