Filter
Top Products
2
SYSTEM CONFIGURATION
2.6 Precautions for System Configuration
2.6.3 Precautions for using database
2
- 21
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.3 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, and Microsoft
®
SQL Server
®
2012, 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)]