13 DATABASE FUNCTION
13.3 CPU Module Database Access (from External Device) Function
243
13
Database access setting
1.
Creating a database
Create a database in an SD memory card of the CPU module. (
2.
Adding a database to the ODBC data source
Add the created database of the CPU module to the ODBC data source of the personal computer. (
database to the ODBC data source)
Database operation
1.
Checking the start-up of the ODBC server
Check that SM1498 (CPU module database start-up flag) is on.
When SM1498 is on, the ODBC server of the CPU module is active. The ODBC server starts and SM1498 turns on when:
• An SD memory card storing the database folder is inserted to the CPU module, and the CPU module is powered off and on
or is reset.
• An SD memory card storing the database folder is inserted to the CPU module powered-on when SD1498 (Start-up status
of CPU module database) is 0H.
Whether or not the ODBC server has been started up can be checked in SD1498 (Start-up status of CPU module database).
The active ODBC server stops when:
• The SD memory card is disabled (SD memory card forced disable) or the SD memory card is removed.
• The CPU module is powered off.
• The data memory is initialized.
• Free space of the SD memory card is less than 10MB.
2.
Connecting to a database
Start an application (Microsoft Access, Excel, or the user-created application) on a personal computer and connect it to a
database specified with the application. (
3.
Operating a database
Operate an application on a personal computer to operate a database. (
The SD memory card is accessed when the ODBC server is started up. This may lengthen the processing
time of other functions that use the SD memory card.
Содержание MELSEC iQ-R-R00CPU
Страница 2: ......
Страница 151: ...9 MONITOR FUNCTION 9 1 Real Time Monitor Function 149 9 MEMO ...
Страница 323: ...18 SEQUENCE SCAN SYNCHRONIZATION SAMPLING FUNCTION 321 18 MEMO ...
Страница 330: ...328 20 ROUTING SETTING 20 3 Precautions MEMO ...
Страница 423: ...26 BASIC CONCEPT 26 8 State Transition of the Redundant System 421 26 MEMO ...
Страница 524: ...522 30 MAINTENANCE AND INSPECTION FOR A REDUNDANT SYSTEM 30 1 Module Replacement in the Redundant System MEMO ...
Страница 1009: ...APPX Appendix 14 List of Available SQL Commands for CPU Module Database Access Function 1007 A MEMO ...
Страница 1014: ...1012 APPX Appendix 15 Added and Enhanced Functions MEMO ...
Страница 1027: ......