When running a report within Access Supply Chain.
There Is a message that either a connection cannot be made to the SQL server or the server is not found, then an ODBC login prompt appears, at this stage entering the correct SQLserver details does not fix the issue.
Sometimes a user also gets the Failed to open the connection error message when running Crystal reports through Access Supply Chain.
These errors have probably been caused by the installer failing on a new Client Installation, with the MadiSunSQL data source needed for the Crystal Report not having been created. The Person that installed the New Client will have seen this error as part of the process and should have been able to fix it. So this needs to go back to them as they will have the connection details and password.
On the affected machine, the solution is to.
Navigate to the following; C Drive, Windows, SysWOW64 directory and right click on odbcad32.exe and run as administrator
Using the menu at the top navigate to System DSN.
Press on Add and select relevant SQL Server Client.
Insert the following:
Name: MadiSunSQL
Description: choose to provide a description or leave it blank
Server: Choose the Supply Chain SQL Server
Choose SQL Server authentication and insert the Login ID and Password that is needed
Leave the following window default and press next.
Leave the following window default and press finish.
Press on Test Data Source to see if the connection has been set correctly.
Finally, press OK to finish the process.