NAV2018 : Resolving Data source name not found and no default driver specified
While working with Microsoft Dynamics NAV development environment, I encountered this error when trying to select the database.
Error: [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified. State ID: IM002
It took me awhile to figure out a way to fix it. To fix this make sure the SQL Server Native Client is installed.
Locate the installation folder and navigate to the “Prerequisite Components” folder within them. This folder contains essential components required for Dynamics NAV. Run the SQL Server Express installer to install the missing component.
Once the installation is complete, you should have the SQL Server Native Client installed on your computer. You can now open the database without encountering the “Data source name not found and no default driver specified” error.