Logging Audit Trails to an SQL Database SECTION 13 CFR (Title 21 Part 11) Function-
210
13-4-13 Viewing the Alarm Error and Events Data Tables
Notice that a new database file will have been created. This will be suffixed
with a number one greater than the previous database. (Refer to the section
Microsoft Access Database File Management below for an explanation of this
function).
Open the new Access database file, login as Guest (if required) and open the
Alarms table which will show a set of records similar to those shown below:
Opening the Events table will show a set of records similar to those shown
below:
Opening the Errors table will show a set of records similar to those shown
below:
13-5
Logging Audit Trails to an SQL Database
The same methods as described above for the Microsoft Access database can
be used to log to an SQL Server Database
To use an SQL Server Database the database must first be created and the
connection string must be configured. CX-Supervisor provides supports for
SQL Server database as detailed below.
The test project described in the section above could be converted to be used.
Содержание CX-Supervisor
Страница 1: ...CX Supervisor Software Cat No W10E EN 01 User Manual Software Release 3 1...
Страница 3: ...Copyright Notice 2...
Страница 16: ...15...
Страница 17: ...16...
Страница 27: ...Tip of the Day SECTION 1 Graphics Editor 26...
Страница 35: ...CX Supervisor Preferences SECTION 2 Pages 34...
Страница 79: ...Responding to Events SECTION 5 ActiveX Objects 78...
Страница 115: ...Printing the Graphics Library SECTION 7 Graphics Library 114...
Страница 181: ...Data Logging SECTION 11 Data Logging 180...
Страница 201: ...Examples SECTION 12 Databases 200...
Страница 243: ...Performance Monitor SECTION 16 Application Analysis Performance Monitor 242...
Страница 253: ...Using with Omron s CX Server OPC SECTION 17 Using CX Supervisor as an OPC Cli 252...
Страница 259: ...Creating a CX Supervisor Client application SECTION 18 Connecting to a remote CX 258...
Страница 263: ...Adding a Point Linked to a Parameter SECTION 19 Connecting to Omron Industrial 262...
Страница 271: ...Data Logging SECTION 20 Best Practices 270...
Страница 275: ...Configuring a Server PC running Windows NT or 2000 Appendix A Configuring a PC 274...
Страница 277: ...Appendix B Frequently Asked Questions 276...
Страница 296: ...Appendix B Frequently Asked Questions 295...
Страница 297: ...Appendix B Frequently Asked Questions 296...
Страница 298: ...Appendix B Frequently Asked Questions 297...
Страница 299: ...Appendix B Frequently Asked Questions 298...
Страница 333: ...Revision history 332...