Mitsubishi Electric QJ71MES96N - 2.6.4 Precautions for using database

2
SYSTEM CONFIGURATION
2.6 Precautions for System Configuration
2.6.4 Precautions for using database
2 - 24
1
OVERVIEW
2
SYSTEM CONFIGURATION
3
SPECIFICATIONS
4
SETTINGS AND PROCEDURE TO OPERATION
5
INSTALLATION AND UNINSTALLATION
6
FUNCTIONS
7
MES INTERFACE FUNCTION CONFIGURATION TOOL
8
DB CONNECTION SERVICE AND SETTING TOOL
2.6.4 Precautions for using database
The following shows the precautions for using database.
For characters that can be used for field and table names, refer to the following:
Appendix 2.4 Characters available for field names, table names, stored
procedure names,etc.
(1) Microsoft
®
SQL Server
®
(a) Set "SQL Server and Windows" or "SQL Server and Windows Authentication
mode" for the security authentication mode.
•Microsoft
®
SQL Server
®
2000
Configure the setting in [SQL Server Properties (Configure)].
•Microsoft
®
SQL Server
®
2000 Desktop Engine (MSDE 2000)
Set the security authentication mode into the Mixed Mode.
Specify the command parameter at installation of the MSDE 2000.
setup sapwd="sa" SECURITYMODE=SQL
(sa: Specify any password)
(b) For Microsoft
®
SQL Server
®
2008/2012/2014/2016/2017 return values, output
arguments, and input/output arguments of a stored procedure which returns a
result set cannot be acquired.
Figure 2.11 [SQL Server Properties (Configure)]