Logging Audit Trails to an SQL Database SECTION 13 CFR (Title 21 Part 11) Function-
212
13-5-3 Connection String for an SQL Database
Invoke the Audit Trail Configuration dialog, select the ‘SQL Server’ radio
button in the Database group and press the ‘Setup…’ button, this will display
the ‘Audit Database Setup’ dialog as shown below:
NOTE: The connection string will be empty initially.
In the Database text box type in the name of your chosen database (for the
test application we created a database called ‘Audit’) and then press the ‘Build
Connection String’ a default connection string will be built for you as shown
below:
NOTE: The default connection string assumes that the SQL Server is local, if
this is not the case for your system replace ‘(local)’ with your <server
address>.
When you have the required ‘connection string’, press the Ok button to save
the new settings. If an error message indicating that the connection string is
invalid is displayed, press ‘No’ to go back and correct the error. If the message
still appears, but you are happy that the connection string is valid for your
system, then press the ‘Yes’ button to save your connection string. Press Ok
on the Audit Configuration Dialog to complete the process and re-build the
project, after a successful build the project is now ready to log to SQL Server.
Содержание 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...