Job Management Partner 1/Asset Information Manager Planning and Setup Guide

[Contents][Glossary][Index][Back][Next]

5.5.1 Creating a data source (for Microsoft SQL Server)

To create a data source, specify information about the database to be connected.

The following shows the dialog box for creating a data source.

Figure 5-12 Dialog box for creating a data source (for Microsoft SQL Server)

[Figure]

To return to the list of connection targets, click the Back button.

To create a data source:

  1. In the dialog box for creating a data source, specify Server and Database name.
    The following describes each item in the dialog box.
    • Server
      Specifies the server name of the database to be connected. The permitted value is 1 to 63 bytes of alphanumeric characters, %, ~, -, _, ., /, and \. By default, this item is blank.
    • Database name
      Specifies the name of the database to be connected. The permitted value is 1 to 128 bytes of alphanumeric characters and symbols, excluding ", |, -, *, :, <, >, ?, /, and \. By default, this item is blank.
    • ODBC data source name
      Displays the value specified in the Server Setup dialog box. This item cannot be changed. The displayed value depends on the product selected in Products for connection. The following table shows the items in the Server Setup dialog box that correspond to the selected product.

      Table 5-7 Items in the Server Setup dialog box that correspond to the selected product (ODBC data source name)

      Selected product Item in the Server Setup dialog box
      Asset Information Manager Service name
      JP1/Software Distribution Connection service for JP1/SD database
    • Connection user ID
      Displays the value specified in the Server Setup dialog box. This item cannot be changed. The displayed value depends on the product selected in Products for connection. The following table shows the items in the Server Setup dialog box that correspond to the selected product.

      Table 5-8 Items in the Server Setup dialog box that correspond to the selected product (connection user ID)

      Selected product Item in the Server Setup dialog box
      Asset Information Manager Login ID
      JP1/Software Distribution JP1/SD database login ID
  2. Click the OK button.
    The data source is created according to the specified settings. When the data source creation is completed, a message to that effect is displayed.
  3. Click the OK button.
    The dialog box for creating a data source is closed and the list of connection targets is displayed again.