SmartConnect Error: Data source name not found…

Microsoft Dynamics GPI’ve recently been working on a SmartConnect project with a client. Integrations were created, tested and signed off as working by the members of the project team. However, when additional users starting using SmartConnect, an error was encountered by some users, not all, running the integrations:

Error running integration

Connection could not be validated

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

The integrations were using an Excel file data source and, when checked, the users having problems had the 64-bit version of Microsoft Office installed and the working ones had the 32-bit version. You don’t need to replace the whole office installation, just install the 32-bit version of the Microsoft Access Database Engine 2016 Redistributable from the command line as a silent install.

Access Database Engine Redistributable Command Line Install

Microsoft Dynamics GPIn the last post I discussed installing the correct version of the Access Database Engine Redistributable. One further point to remember is that the x64 distributable cannot be installed in the normal way if the x86 version of Microsoft Office is installed.

However, it can be installed using the command line. This is not a post I can take credit for (I’m posting to help me remember for future reference) as it was first covered by the Dynamics GP Blogster (AKA Mariano Gomez) over twelve months ago.

To installed the x64 Access Database Engine Redistributable via the command line, open a command prompt and navigate to the location of the installer and type the following:

AccessDatabaseEngine_x64.exe /quiet

If you’re installing the x86 by the command line, just omit the _x64.

Access Database Engine Redistributable for FRx Migration Wizard

Microsoft Dynamics GPIf you intend to use the FRx Migration Wizard when upgrading a client to Management Reporter then you need to have the Access Database Engine Redistributable installed on the same machine as the Migration Wizard.

And more than just having it installed, you need to have the correct version installed because in either case you will receive the following error:

Management Reporter - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.Management Reporter – The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

The important item to remember is that there are two versions of the redistributable; x86 and x64. The version required is the one which matches the operating system. So for example, an x64 OS with x86 Office, needs the x64 version installed.