知識庫

Error Occurred When Using ODBC SQL Server Driver with Other Databases(ODBC) Connector in Tableau Prep


發佈時間 : 27 Apr 2022
上次修改日期 : 09 Dec 2022

問題

Could not connect to a SQL Server data source using ODBC connector with ODBC SQL Server Driver in Tableau Prep Builder 2021.4 with the error below: 

An error occurred while communicating with Other Databases(ODBC).
[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot open database "XXXX" requested by the login.
Login failed. Additional configuration is required for generic ODBC.
The driver and DSN (data source name) must be installed and configured to verify the connection.
Cannot connect using a DSN named "XXXX".
Please verify that the DSN exists and is a valid connection.

環境

  • Tableau Prep Builder 2021.4.3

其他資訊

This issue is specific to the use of Other Databases (ODBC) to connect to SQL Server data source.
這篇文章是否解決了問題?