Hello,
As I installed a win32 machine dedicated to PlugWise and as I want to read directly the mdb file, I am using ActivePerl via ODBC to read mainly the appliances_log table.
The point I am willing to know is wheather reading the access file (ODBC read only) may corrupt it. (As of your experience, not as general Access question )I noticed some inconsistencies while polling it. (I had even to reinstall the software, some tables were illisible (once more, via the ODBC stuff)). I do not know if Access permits "consistent reads" and if my readings from the mdb may harm the genuine Plugwise update.
By the way, I already had to reinitialize two Circles, they didn't communicate any more with the others (they were relly near the others). The plugout/wait/plugin three times did the trick (as I saw on Domotica, the Dutch sentence on Plugwise site is ... in Dutch)
Regards, Radu
RC
Reading Modules from PlugwiseData.mdb
Reading Modules from PlugwiseData.mdb
Hi Radu,
If you don't poll more than every 30 sec you might consider copying the database file first before reading it, that way you will never corrupt the data I think.
Darwusch
If you don't poll more than every 30 sec you might consider copying the database file first before reading it, that way you will never corrupt the data I think.
Darwusch
Reading Modules from PlugwiseData.mdb
Hi Darwusch,
Thank you for your reply. Yes, I arrived at this solution as I poll every minute the mdb file and I have 27 modules (The perl routine slows down and mdb file is almost constantly being used by Source Software).
Radu
RC
Thank you for your reply. Yes, I arrived at this solution as I poll every minute the mdb file and I have 27 modules (The perl routine slows down and mdb file is almost constantly being used by Source Software).
Radu
RC
Reading Modules from PlugwiseData.mdb
I did the same thing for Graphs. Copying the DB every 5 minutes just to make sure the file isn't locked and I won't mess up the DB.
DJ
DJ
Reading Modules from PlugwiseData.mdb
That's the best solution. Messing up the db makes the software to crash.