Mitsubishi Electric MELSEC iQ-R Series User Manual page 122

Access
(Example) Windows 7
The following shows the setting example of ODBC setting in the following conditions.
Item
Relational database
*1
Data source name
*2
Database name
*1 A data source name can be set arbitrary.
The name set in this setting is used as a name to be entered for "Data Source Name" under "Target Server Individual Settings" in "Target
Server Settings."
*2 The database name is a name for accessing a Microsoft Access database.
Specify the file path of the database created with Microsoft Access.
APPX
120
Appendix 2 ODBC Setting
Description
Microsoft Access 2010(32bit)
SAMPLE
C:\MES\Sample_DB.accdb
1.
Start ODBC Data Source Administrator.
Page 116 Starting ODBC Data Source Administrator
2.
Select the [System DSN] tab and click the [Add] button.
3.
Select "Microsoft Access Driver(*.mdb, *.accdb)", and
click the [Finish] button.
4.
Enter 'SAMPLE' in the "Data Source Name" and click
the [Select] button in the "Database".
5.
Select 'Sample_DB.accdb' in the "Database Name" and
click the [OK] button.
6.
Select "None" in the "System Database" and click the
[OK] button.
7.
Click the [OK] button in the "ODBC Data Source
Administrator" screen.