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
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
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