How to access a different database from FRx

Entry Type: Informational

Product: Sage MAS 500 ERP

Application: FRx Desktop

Version Reported: 6.5

Subject:

How to access a different database from FRx.

Possible Resolution:

FRx for Sage MAS 500:

Change the system DSN that FRx uses to access Sage MAS 500.

1. In FRx Designer, select Company / Information.
2. Select the company, and click the 'System Specification' tab.
3. Click the 'Define' button.
4. Click the 'System DSN' tab, and select the datasource that FRx uses to access Sage MAS 500 data (normally "Acuity-app").
5. Click the 'Configure' button, and verify that the name and server are correct. Click 'Next'.
6. Select the appropriate authentication method below, and click 'Next':
• Windows NT authentication
• SQL Server Authentication
• Enter the SQL username and password.
7. Select the appropriate database, and click 'Next'.
8. Click 'Finish', and then click the 'Test Datasource' button to verify a successful connection to the SQL Server.
9. Click 'OK' to close the window.