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

Product:  BizInsight
Applies to:  MAS 90/200
Article Type:  Error 

Summary:
After installing and configuring an environment for BizInsight, a user drags and drops a BizInsight function into Excel and receives the following error:

Error:  System.Data.SqlClient.SqlError:  OLE DB provider "MSDASQL" for linked server MAS90_xxx" returned message "[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified"

This error can also occur when changing a function’s CompanyCode parameter to a different company.
 
Details:
This error indicates a configuration problem with either the ODBC data source for that company or with the data source name specified for that company’s linked server.

Resolution/Workaround:
To troubleshoot this issue, do the following:

1.  On the server where the linked servers exists, go to Administrative Tools > Data Sources (ODBC) and check the ODBC data source for the company.
     a. Verify that an ODBC data source has been created for the company.
     b. Perform a test connection of the data source and make sure that the test connection works.

2. Start SQL Server Management Studio, locate the linked server for this company, right-click on the linked server, and click on Properties to check its properties.
     a. Confirm that the ODBC data source name in both the Provider and Data Source fields is correct.  If either value is incorrect, the linked server object will need to be deleted and recreated.
     b. Open a new query window and run the following query:

               Select * from openquery(mas90_xxx, ‘select * from GL_Account’)

         If the query results in an error, recreate the ODBC data source for this company

If the provided Resolution/Workaround does not resolve your issues, please contact BizNet Software Support for further assistance.