Versions Compared

Key

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

...

  1. From the FactoryLogix Application Server, access the system's ODBC Data Source Administrator by selecting Start > Administrative Tools > Data Sources (ODBC).

  2. On the System DSN tab, select Add to add a system data source.

    ODBS Data Source Administrator options
  3. Select SQL Server Native Client 11.0 or SQL Server Native Client RDA 11.0 to select the driver, then select Finish.

  4. In the Create a New Data Source to SQL Server dialog, enter a Name for the connection (FUSION, for example), and (optionally) a Description in the fields provided.

    Create a New Data Source to SQL Server
  5. Under Which SQL Server do you want to connect to? enter the SQL Server name or IP address or select from drop-down, then select Next.

  6. Do one of the following to select an authentication method:

    • If using Windows authentication, select the With Integrated Windows authentication button.

    • If using SQL authentication, select the With SQL Server authentication using a login ID and password entered by the user button.

      • Enter the SQL user Login ID.

      • Enter the SQL user Password.

        Select an authentication method
  7. Select Next.

  8. Enable the Change default database to: check box, then select the Fusion database from drop-down.

    Change Default Database To dialog
  9. Accept the other default settings, then select Next.

  10. Accept the defaults on next page, then select Finish.

    Accept default settings, then select Finish
  11. Select the Test Data Source button. The system should respond with the message Test completed successfully.

  12. Select OK and exit ODBC Administrator.

...