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.
To Next Page
Loading...
Need help?
General