I have an excel workbook which has an external data source to create a pivot table. This file was sent to me. I can open it up correctly, but when I try to refresh the data I get the following error:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
As far as I'm concerned, Windows should use the default ODBC driver (odbcad.exe) for the connection. Any idea what might be causing the error when refreshing the data?
EDIT: The connection string has DSN, UID, TRUSTED_CONNECTION, APP, WSID and DATABASE fields.
EDIT: I set up the ODBC connection, but now I'm getting the following error:
[ODBC Driver Manager] The Specified DSN contains an architecture mismatch between the Driver and Application