Omron NX701-1620

2 DB Connection Settings
2-10
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Category Item Description Value
method.
Host name Set the host name of the server.* Default: Blank
This setting cannot be omitted when Host
name is selected for Server specification
method.
Instance name /
Port No.
Set the instance name or port
number of the server.
 Oracle:
Port No. (Can be omitted)
e.g. 1521
 SQL Server:
Instance name or Port No. (Can be
omitted)
e.g. INSTANCE1 or 1433
 DB2:
Port No. (Cannot be omitted)
e.g. 50000
 MySQL:
Port No. (Can be omitted)
e.g. 3306
 Firebird:
Port No. (Can be omitted)
e.g. 3050
 PostgreSQL
Port No. (Can be omitted)
e.g. 5432
Maximum number of characters for instance
name: 64 characters
Port No.: 1 to 65535
Default: Blank
When omitted, the default port number is
used.
 Oracle: 1521
 SQL Server: 1433
 MySQL: 3306
 Firebird: 3050
 PostgreSQL: 5432
Service name/
Database name
Set the service name or database
name in the server.
 Oracle: Service name (Can be omitted)
 SQL Server: Database name (Can be
omitted)
 DB2: Database name (Cannot be omitted)
 MySQL: Database name (Cannot be
omitted)
 Firebird: Database path (Cannot be
omitted)
e.g., C:/Firebird/OMRON.FDB
 PostgreSQL: Database name (Cannot be
omitted)
Maximum number of bytes: 127 bytes
When omitted,
 Oracle: Default service

SQL Server: Default database