ODBC Driver Manager - Data source name not found and no default driver specified

[Guest ITHelpLine]

We have many reports (scripts) that are setup in SAP business one environment and in the past we used Microsoft office 2013 64 bit and users were able to run the reports from their local desktop using Microsoft office 2013 64bit.

 

However, we have recently upgraded our system to Microsoft office 2016 64 bit and now no user can run the reports from their local machine. We have installed the ODBC driver 64bit and even tried the 32bit driver:

 

- The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.

- The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

 

Connect to an ODBC source

 

We have also installed the Microsoft Access 2016 Runtime but the issue continues.

 

That said, we can run the report from the SAP Terminal server with no problem.

 

Any help/recommendation will be much appreciated!!!!!

 

Thank you in advance.

 

More...