Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Jul 13, 2022, 6:14 PM

I'm running Tableau Desktop version 2022.1.3 and started getting the error below today. Anyone know what I need to do to fix this?

An error occurred while communicating with the Other Databases (ODBC) data source 'HRxs+ (FWDB)'

 

Error Code: 2F0F5E42

[Microsoft][ODBC SQL Server Driver][SQL Server]An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

1 answer
  1. Dan Cory (Salesforce)
    Jul 13, 2022, 7:28 PM

    Do not use Other Databases (ODBC) to connect to a database for which Tableau has native support. Use the native connection Microsoft SQL Server connection instead. The native connection has been optimized to account for all the quirks in that database.

     

    Dan

Write an answer...
0/9000