Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open Data Sources (ODBC).
  2. Select the System DSN
  3. Click the Add The Create New Data Source dialog will be displayed.
  4. Select SQL Native Client 10.0.
  5. Click the Finish The Create a New Data Source to SQL Server dialog will be displayed.
  6. Enter the following details:
    • Name: FworkSQLSAMaster
    • Description (optional): Enter a description for the database connection. For example, Framework Sales Advice Master.
    • Server: Select the SQL Server from the Server drop-down list.
      OR
      Enter the SQL Server name.

      Info
      If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS


  7. Click the Next
  8. Click the Next
  9. Tick Change the default database to.
  10. From the drop-down list select: FworkSQLSAMaster

    Info

    If your installation does not use a FworkSQLSAMaster database, select the FworkSQLSA database in this step.


  11. Click the Next
  12. Click the Finish The ODBC Microsoft SQL Server Setup dialog will be displayed.
  13. Click the Test Data Source...
  14. If successful, click the OK
  15. Click the OK The ODBC Microsoft SQL Server Setup dialog will close.
  16. Click the OK The Data Sources (ODBC) dialog will close.

...