Filter
Top Products
8
DB CONNECTION SERVICE AND SETTING TOOL
8.2 Setting ODBC to the Database
8
- 6
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
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) For Oracle
®
(The following shows a setting example using Oracle
®
9i with Microsoft
®
Windows
®
XP Professional Operating System.)
Set the following conditions.
• Data source name
*1
: SAMPLEDS
• TNS service name
*2
: SAMPLETNS
• OracleHome: OraHome92
*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
®
.
(Start)
1 Clicking [Performance and Maintenance
*3
] on the
Control Panel displays the [Performance and
Maintenance
*3
] dialog box.
To display the Control Panel, select [Start]
[Control Panel].
*3 For Windows Vista
®
, Windows Server
®
2008:
System and Maintenance
For Windows
®
7, Windows Server
®
2008 R2, Windows
®
8,
Windows
®
8.1, Windows Server
®
2012,
Windows Server
®
2012 R2:
System and Security
2 Clicking [Administrative Tools] displays
[Administrative Tools] dialog box.
(To the next page)