![background image](http://html1.mh-extra.com/html/omron/cx-supervisor/cx-supervisor_user-manual_744211212.webp)
Logging Audit Trails to an SQL Database SECTION 13 CFR (Title 21 Part 11) Function-
211
13-5-1 SQL Server Database Prerequisites
The following conditions need to apply before logging to an SQL Server
database can proceed:
1. Ensure you have access to an SQL Server.
2. The necessary security permissions are applied to update the database to
be used for audit logging.
3. A database is created to be used for the Audit Trail.
NOTE: Once the SQL Server database exists. CX-Supervisor will create the
required tables in the specified database (if they do not already exist) namely,
Points, Alarms, Events and Errors. The same tables as are created for the
Microsoft Access database.
4. The database name has been correctly specified in the Audit Trail
Configuration settings.
5. The connection string has been specified correctly.
13-5-2 Creating an SQL Server Test Project
To create a test application, convert the test project described in the sections
above,
Or
Create a test project as described in the sections ‘Creating and Running a
CFR Application (using Microsoft Access).
Then select the SQL Server option in the Audit trail Configuration settings
dialog.
Summary of Contents for CX-Supervisor
Page 1: ...CX Supervisor Software Cat No W10E EN 01 User Manual Software Release 3 1...
Page 3: ...Copyright Notice 2...
Page 16: ...15...
Page 17: ...16...
Page 27: ...Tip of the Day SECTION 1 Graphics Editor 26...
Page 35: ...CX Supervisor Preferences SECTION 2 Pages 34...
Page 79: ...Responding to Events SECTION 5 ActiveX Objects 78...
Page 115: ...Printing the Graphics Library SECTION 7 Graphics Library 114...
Page 181: ...Data Logging SECTION 11 Data Logging 180...
Page 201: ...Examples SECTION 12 Databases 200...
Page 243: ...Performance Monitor SECTION 16 Application Analysis Performance Monitor 242...
Page 253: ...Using with Omron s CX Server OPC SECTION 17 Using CX Supervisor as an OPC Cli 252...
Page 259: ...Creating a CX Supervisor Client application SECTION 18 Connecting to a remote CX 258...
Page 263: ...Adding a Point Linked to a Parameter SECTION 19 Connecting to Omron Industrial 262...
Page 271: ...Data Logging SECTION 20 Best Practices 270...
Page 275: ...Configuring a Server PC running Windows NT or 2000 Appendix A Configuring a PC 274...
Page 277: ...Appendix B Frequently Asked Questions 276...
Page 296: ...Appendix B Frequently Asked Questions 295...
Page 297: ...Appendix B Frequently Asked Questions 296...
Page 298: ...Appendix B Frequently Asked Questions 297...
Page 299: ...Appendix B Frequently Asked Questions 298...
Page 333: ...Revision history 332...