Mitsubishi Electric QJ71MES96N - 8.2 Setting ODBC to the Database

8 - 6
8.2 Setting ODBC to the Database
8
DB CONNECTION SERVICE AND SETTING TOOL
8.2 Setting ODBC to the Database
When using DB Connection Service on the database server computer, the ODBC setting
for the database to be used must be set beforehand.
The following explains the ODBC setting procedure.
For details, refer to the following.
Manuals and online help for the database software and operating system used
(1) ODBC driver
Only the ODBC driver installed at the same time as the installation of the database
can be used except for the cases below.
'Microsoft Access Driver(*.mdb)', 'Microsoft ODBC for Oracle', and 'SQL Server' which
are supplied with the operating system cannot be used.
• Before connecting an Oracle database using DB Connection Service Version
2 (32-bit), install the 32-bit version of Oracle Client.
(2) To start the ODBC Data Source Administrator
When the installation method of Access is Click-to-Run (C2R), install Microsoft
Access database engine 2010 first, then start "ODBC Data Source Administrator".
Enter the following command in the command prompt in accordance with the software
version of MX MESInterface and the version of DB connection service to be used.
(3) For Oracle
®
(The following shows a setting example using Oracle
®
12c with Microsoft
®
Windows
®
7 Professional Operating System.)
Set the following conditions.
• Data source name
*1
: SAMPLE
•TNS service name
*2
: SAMPLETNS
• OracleHome: OraClient12Home1
*1 Data source name can be set as desired.
For [Data source name] in [Server service settings], use the name set with this setting.
*2 The TNS service name is the name for accessing an Oracle
®
database.
The name is entered when installing Oracle
®
and creating a database instance.
This can be checked with [Configuration and Migration Tools] - [Net Manager] - [Service naming] of
Oracle
®
.
DB Connection Service and DB Connection Service Setting Tool Command
DB Connection Service and DB Connection Service Setting Tool Version 1
"%SystemRoot%\SysWOW64\odbcad32.exe"
DB Connection Service and DB Connection Service Setting Tool Version 2 (32-bit)
DB Connection Service and DB Connection Service Setting Tool Version 2 (64-bit) "%SystemRoot%\system32\odbcad32.exe"