Login ID specifies the login ID of the user who will be connecting to the database. For details about creating a database field, see 5.4 Creating an asset management database.

In the Set Password dialog box, set the password.

This setting is mandatory.

• Permitted value
  From 1 to 29 bytes of characters (Login ID and password). For Embedded RDB, specify from 1 to 8 bytes of characters as Login ID. By default, both Login ID and the password are admin.
  Depending on the type of DBMS, some limitations apply to the values that can be specified for Login ID and password. The following table describes the limitations for each DBMS.
  

  Table 5-1 Limitations that apply to Login ID and password

  DBMS type	Limitations
  Microsoft SQL Server	!, (, ), *, ,, ;, =, ?, @, [, ], {, }, and spaces cannot be specified.
  Embedded RDB	Only the following characters can be specified: Letters (A to Z and a to z) Numeric values (0 to 9) A letter must be specified for the first character.
  Oracle	" cannot be specified.

This value is applied to Connection user ID in the dialog boxes listed below. If you change the value after creating a new asset management database, re-create the data source or net service.

• Basic Database Settings dialog box
• Dialog box for creating a data source (for Microsoft SQL Server or Embedded RDB)
• Dialog box for creating a net service (for Oracle)

Service name specifies the service name for asset management.

Specification of this item is mandatory.

• Permitted value
  1-63 bytes of alphanumeric and special characters. The default is ASSET_DB_SERVICE_NAME.
  Depending on the type of DBMS, some limitations apply to the value of Service name. The following table describes the limitations for each DBMS.
  

  Table 5-2 Limitations that apply to Service name

  DBMS type	Limitations
  Microsoft SQL Server and Embedded RDB	!, (, ), *, ,, ;, =, ?, @, [, ], {, }, and spaces cannot be specified.
  Oracle	!, ", #, $, %, &, ', (, ), *, +, ,, /, :, ;, <, =, >, ?, @, [, \, ], ^, `, {, |, }, ~, and spaces cannot be specified.

This value is applied to ODBC data source name and Net service name in the dialog boxes listed below. If you change the value after creating a new asset management database, re-create the data source or net service.

• Basic Database Settings dialog box
• Dialog box for creating a data source (for Microsoft SQL Server or Embedded RDB)
• Dialog box for creating a net service (for Oracle)

Number of concurrent connections specifies the number of connections that can be established with the database at the same time.

Specification of this item is optional.

• Permitted value
  1-64. The default is 20. Specify a value that is greater than the value of Number of connections for search in Database Information.
  

Number of connections for search specifies the number of concurrent connections that can be established by transactions that use the database for an extended period of time. By specifying this setting, you can prevent the database from being locked by a long-running transaction such as a search request.

Specification of this item is optional.

• Permitted value
  1-64. The default is 5. The value of this item must be less than the value of Number of concurrent connections in Database Information.
  

Case sensitivity in LIKE searches (Embedded RDB) specifies whether the search is to be case-sensitive when Embedded RDB is used to search for a partial match, including a leading or trailing match.

• Permitted value
  
  • Case sensitive (default)
    The search is case-sensitive.
    
  • Case insensitive
    The search is not case-sensitive.