AGG Software Forums
September 20, 2024, 01:34:17 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
   Home   Help Search Login Register  

Pages: [1]
  Print  
Author Topic: Advanced OPC Datalogger w/local db module  (Read 19768 times)
oedge
Newbie
*

Karma: +0/-0
Posts: 4


View Profile
« on: November 16, 2011, 08:51:19 PM »

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?
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #1 on: February 24, 2016, 02:00:00 PM »

Could you please, create a backup of your current configuration (from the "File" menu) and attach it here? I'll verify it.
Logged
oedge
Newbie
*

Karma: +0/-0
Posts: 4


View Profile
« Reply #2 on: March 22, 2016, 02:00:00 PM »

OK here it is....

* CurrentConfig.zip (1.93 KB - downloaded 2 times.)
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #3 on: April 01, 2016, 02:00:00 PM »

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).
Logged
oedge
Newbie
*

Karma: +0/-0
Posts: 4


View Profile
« Reply #4 on: April 22, 2016, 02:00:00 PM »

Great. Thanks a lot.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines