Advanced OPC Datalogger w/local db module

Started by oedge, November 16, 2011, 05:51:19 PM

Previous topic - Next topic

oedge

With local database type set to MS Access, on the Columns Order screen, I add the first item as Datetime (Parser item name = DATE_TIME_STAMP), and the second as TankTemp1 (Parser item name = AutomationDirect.KEPDirect.V5.Temp1). The database starts sucessfully with a table named SERIAL_DATA, which has two fields named Datetime Stamp, and OPC item.

If I add a third item named Temp2 (Parser item name = AutomationDirect.KEPDirect.V5.TankTemp2) the database field is create but it has no table. Instead I get an error: Local database Could not write to file (Cannot define field more than once). It seems to me that the local db module has a bug that tries to set all field names to OPC item. Is this correct or am I doing something wrong?

Arthur Grasin

Could you please, create a backup of your current configuration (from the "File" menu) and attach it here? I'll verify it.
If you like my work, please take a few seconds and add feedback about our site or our software [here]


Arthur Grasin

The problem with duplicate columns has been fixed. Please, download the update here:
http://www.aggsoft.com/download/localdb.exe

Also, I would recommend to make the following changes:

1. In the OPC group settings disable the "Add server name" option (because the access doesn't allow long names).
2. In the "Local database" plugin change parser names to new values (without the server name).
If you like my work, please take a few seconds and add feedback about our site or our software [here]