Reinstalling ASC on a User's machine and the following error generates:
Error 1919. Error configuring ODBC data source MadisunSQL, ODBC error 6: Component not found in the registry. Verify that the file MadisunSQL exists and that you can access it.
As part of the Supply Chain install an ODBC data source is created. This is required for reports to run successfully.On a 64-bit machine the data source is configured in C:\Windows\SysWOW64\odbcad32.exe. It must be set up as a System DSN. Just for your information, the name Madisun comes from the original name for the software prior to being acquired by Access. The MadisunSQL data source must be a SQL Server driver, and must use SQL authentication. It uses the sa login, then the default settings are used. There is no default database defined in the data source. The SQL Server it connects to is the SQL instance where the Supply Chain database is set up.
The MADISUN.INI file (located in "C:\Program Files (x86)\Access Applications\ASC7.2.2\Client Application\ on the client PC) must be amended so that all the paths in it point to the test server.
The MadiSunSQL ODBC connection will also need to be changed to point to the test SQL instance. I’ve attached instructions on how to configure the ODBC
Once you’ve done this, the Client Update should pull down the correct version to the ASC system:
In Windows Explorer navigate to C:\Windows\SysWOW64\ODBCAD32.exe. Double click this to run the ODBC Data Source Administrator (32-bit).
2. Select the System DSN tab.
3. Within here there should be a MadisunSQL data source configured.
4. If this does not exist click the Add option on the right-hand side.
5. Select SQL Server (check which driver we recommend) and click Finish.
Users will now see the Create a New Data Source to the xxx screen.
1. Enter the name ‘MadisunSQL’ – it is essential that this is spelt correctly.
2. The description is free text, so enter a description here if required.
3. Select the SQL Server to connect to from the drop-down list.
4. Click Next to continue.
5. Select the second option on the next screen to use SQL Server authentication, and enter the sa username and password.
6. Click Next to continue.
7. Accept the defaults on this screen, making sure that there isn’t a default database defined.
8. Click Next to continue.
9. Accept the defaults on the screen, and then click Finish.
10. At this point, users can test the data source to make sure it connects successfully.
11. Click OK to complete setup.
Note: MadisunSQL MUST be 32 bit.