I have an odd issue with Excel 365 v16.0.16827.20278 installed on a host machine. When trying to access an ODBC source, used successfully by several other individuals, Excel throws the error
An error occurred but no ODBC error information was available
This error can only be triggered from Excel on this single computer from this users profile. Knowing that there are some heavy handed solutions to this e.g., rebuild local computer profile and possibly reinstall Office. I was curious if there was more surgical options.
On the same computer I can do the following without issue:
- Perform a source test successfully from odbcad32.exe
- Run a PowerShell Script to pull one record using the odbc source as the troubled user
- Use Microsoft Access for 365 and use the same ODBC source to pull data
- Run Excel as myself in my own profile on the same computer to use the ODBC connection
I attempted to run a trace using odbcad32.exe under the Tracing tab with Machine-wide tracing for all users identities checked but no log was created. This is in contrast to the tracing test I did on other computers.
Using this ODBC source requires a VPN connection to be established. What is interesting is that the error is the same whether or not the VPN is connected.
My conclusion using the above information is that Excel is the issue under this one local user profile. However, I don't know where to go with that information. The application itself appears to be working fine so repair/reinstall doesn't seem like a viable approach. Rebuilding the local profile is a last resort that I am trying to avoid for the time being.