Industrial Automation
Industrial Automation | Europe

myKnowledge

Main > Product Type > Software > Visualisation
Minimize Text   Default    Enlarge Text
 

Print
E-mail

How Do I Connect To The CX-Supervisor Audit Trail In My Application?


CX-Supervisor allows generation of a password protected audit trail, this can be saved in Microsoft Access format or to an SQL database.
 
It is possible to read this database and display it in CX-Supervisor using the standard database functionality. For SQL based databases the usual File DSN must be created to include the security details for your particular database. Microsoft Access databases require use of a special security file which is created in your CX-Supervisor Application folder to connect to the database.
 
In version 3.0 and 3.1 the audit trail was written by default to a Microsoft Access MDB file. The connection string for this format is in the user manual and should be as follows:
 
Driver={Microsoft Access Driver (*.mdb)};
DBQ=C:\myapplicationfolder\AuditTrail\myapplication_20101008_1.mdb;
SystemDB=C:\myapplicationfolde\myapplication_Audit.mdw;
Uid=Guest;
 
You need to insert appropriate path and file names. 
 
From version 3.2 the output format changed to use the accdb file format, the connection string for this is now:
 
Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:\myapplicationfolder\AuditTrail\myapplication_20101008_1.accdb;
Jet OLEDB:System database=C:\myapplicationfolde\myapplication_Audit.mdw;
User ID=Guest;




Comments (View All Comments / Add Comment)

Related Articles
No related articles found.
Created 2012-11-28
Modified 2013-02-19
Views 2562

 

You are not logged in.