Omron NX701-1620 User Manual

1 Introduction to the DB Connection Service
1-6
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
• NJ501-1300 for NJ501-1320
• NJ501-4300 for NJ501-4320
• NJ101 for NJ101-@@20
*2 Connections to the DB on the cloud are not supported.
*3 When two or more DB Connections are established, the operation cannot be guaranteed if
you set different database types for the connections.
*4 Refer to 5-2-9 How to Estimate the Number of SQL Statements that Can be Spooled for the
information.
Supported DB and Corresponding Versions
CPU Unit
model
Manufacturer name, DB name
Microsoft
Corporation:
SQL Server
Oracle
Corporation:
Oracle
Database
IBM
Corporation:
DB2 for Linux,
UNIX and
Windows
Oracle
Corporation:
MySQL
Community
Edition
*1
Firebird
Foundation
Incorporated:
Firebird
PostgreSQL
Global
Development
Group:
PostgreSQL
*2
NX701-20 Corresponding
version: 2008,
2008R2, 2012,
2014, or 2016
Corresponding
version: 10g,
11g, or 12c
Corresponding
version: 9.5,
9.7, 10.1, 10.5,
or 11.1
Corresponding
version: 5.1, 5.5,
5.6, or 5.7
Corresponding
version: 2.1 or
2.5
Corresponding
version: 9.2, 9.3,
9.4, 9.5, or 9.6
NJ501-20/
NJ101-20
Corresponding
version: 2008,
2008R2, 2012,
or 2014
Corresponding
version: 9.5,
9.7, 10.1, or
10.5
Corresponding
version: 5.1, 5.5,
or 5.6
Corresponding
version: 9.2, 9.3,
or 9.4
NJ501-4320
Not supported.
Not supported.
Not supported.
*1 The supported storage engines of the DB are InnoDB and MyISAM.
*2 When you connect the CPU Unit to PostgreSQL, make the following setting to set the locale
of the PostgreSQL to C. Otherwise, the error messages are not correctly displayed.
Change the value of lc_messages in the postgresql.conf file stored in the data folder under
the installation folder of PostgreSQL and restart the PostgreSQL.
lc_messages = 'C'

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English