Login ID specifies the login ID of the user who will be connecting to the database. This is the login user ID that is used when a database is created for Asset Information Manager Subset. For details about how to create a database, see 10.3.1 Creating a new 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). In Embedded RDB, specify the Login ID as a character string of 1-8 bytes. The default is admin for both Login ID and the password.
  Depending on the type of DBMS, there are limitations to the values that can be specified for Login ID and password. The following table shows the limitations to the values that can be specified in each DBMS.
  

  Table 10-1 Limitations to the values that can be specified for Login ID and password

  DBMS type	Limitations to value
  Embedded RDB	Only single-byte A to Z, a to z, 0 to 9, # @ and \ can be used. The value must begin with an alphabetic character.
  Microsoft SQL Server	!, (, ), *, ,, ;, =, ?, @, [, ], {, }, and space cannot be used.
  Oracle	" cannot be used.

The value set here is applied to Connection user ID in the dialog boxes listed below. If you have changed the value after creating a new database, re-create the data source or net service.

• Basic Database Settings dialog box
• Create Data Source/Net Service dialog box

Service name specifies a service name for the Asset Information Manager Subset database. This is the ODBC data source name (in Embedded RDB or Microsoft SQL Server) or a net service name (in Oracle) that is to be used when a database is created for Asset Information Manager Subset. For details about how to create a database, see 10.3.1 Creating a new database.

Specification of this item is mandatory.

• Permitted value
  From 1 to 63 bytes of alphanumeric characters and symbols. The default is ASSET_DB_SERVICE.
  Depending on the type of DBMS, there are limitations to the value that is specified for Service name. The following table shows the limitations to the values that can be specified in each DBMS.
  

  Table 10-2 Limitations to the values that can be specified for Service name

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

The value set here applies to ODBC data source name and Net service name in the dialog boxes listed below. If you have changed the value after creating a new database, re-create the data source or net service.

• Basic Database Settings dialog box
• Create Data Source/Net Service dialog box

Number of concurrent connections specifies the number of concurrent database connections.

Specification of this item is optional.

• Permitted value
  From 1 to 64. The default is 20. Specify a value that is greater than the value of Number of connections for search in Database Information. If nothing is specified, the default value is used.
  

Number of connections for search specifies the number of processes requiring a long database connection time that can connect to the database concurrently. 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
  From 1 to 64. The default is 5. The value of this item must be less than the value of Number of concurrent connections in Database Information. If nothing is specified, the default value is used.
  

Case sensitivity in LIKE searches (Embedded RDB) specifies whether or not a search is to be case sensitive when partial match searches including leading and trailing match are performed while Embedded RDB is being used.

• Permitted value
  
  • Case sensitive (default)
    Searches are to be case sensitive.
    
  • Case insensitive
    Searches are not to be case sensitive.