Hi,
I need to connect to DV database to access say Control Module/Equipment Module parameters to read and write data from external application. I do not want to use OPC as later on it can become licensing issue if tags increase. I can think of below options:
1. I can use iFix PDB to access iFix points via external application e.g. VBA. Here I need to make point to point mapping between iFix PDB points and DV tags (DST or CM/EM Parameters)
2. I use ADO but I do not know what ActiveX will support to fetch real time data read/write.
3. I use iFix scripting (event or timer events) in VBA to read/write into SQL and let external application to connect to this SQL. This one I am not sure if performance of the overall solution will detoriate.
4. (this one is handy and proven) I write OPC client and read/write to OPC.DeltaV.1.
Please suggest if anyone has done it before. My emerson e-mail address is Samir.Thaker@emerson.com
Andre Dicaire