Skip to main content

Fix Crystal Reports connection errors in Access Supply Chain

Steps to resolve failed connection and ODBC login errors when running Crystal Reports in Access Supply Chain.

A
Written by Andrew McNeice

When running a report in Access Supply Chain, you may see one of the following errors:

  • A message stating that a connection cannot be made to the SQL server, or that the server cannot be found, followed by an ODBC login prompt.

  • A Failed to open the connection error message.

These errors are typically caused by the MadiSunSQL ODBC data source not having been created during a new client installation. You'll need to create this data source manually on the affected machine to resolve the issue.

⚠️Important: You will need the Supply Chain SQL Server name, Login ID, and password to complete these steps. If you do not have these details, contact the person who performed the client installation, as they will have the connection details.

Create the MadiSunSQL data source

To create the missing ODBC data source, follow these steps on the affected machine.

  1. Navigate to C:\Windows\SysWOW64, right-click odbcad32.exe, and select Run as administrator.

  2. Using the menu at the top, navigate to the System DSN tab.

  3. Click Add and select the relevant SQL Server client.

  4. Insert the following details:

    • Name: MadiSunSQL

    • Description: Optionally provide a description, or leave this blank.

    • Server: Enter the Supply Chain SQL Server name.

  5. Select SQL Server authentication and enter the Login ID and password.

  6. Leave the next window at its default settings and click Next.

  7. Leave the following window at its default settings and click Finish.

  8. Click Test Data Source to verify the connection has been set up correctly.

  9. Click OK to complete the process.

📌Note: If the data source test fails, double-check the server name, Login ID, and password with the person who performed the client installation.

Related Articles
Did this answer your question?