Loading

Database error 0x80004005: ODBC connection failed" Error

Publiseringsdato: Feb 21, 2025
Beskrivelse
When connecting to a Microsoft Access query based on a linked table, you may see the following error message:

Database error 0x80004005: ODBC--connection to '<database>' failed.
 
The same error may also occur when connecting to Microsoft Access file that contains links to a Microsoft SQL Server database that uses authentication.

Cause

  • In the first case, the issue is caused by limitation in Access and likely related to database authentication when using linked tables.
  • In the second case, it is not possible to pass the SQL Server credentials to the database from Access. 
Løsning
To resolve the issue when performing a query from an Access linked table, you can do one of the following tasks:
  • Make the query into a table using Access in Design view.
  • Alternatively, you can import the tables referenced in the query instead of using linked tables.
User-added image

To resolve the issue when connecting to an Access file that links to a SQL Server database that uses authentication, connect directly to SQL Server from Tableau Desktop.  
Flere ressurser

Knowledge-artikkelnummer

001473591

 
Laster
Salesforce Help | Article