REXYGEN Community Forum

hubc

Member

Registered: 2016-09-05

Posts: 60

ODBC saving to database problem

Hello all!

Recently I moved to the new version of Rex (project files was converted by RexDraw), and I'm facing some issues with saving data to the database.
Did something changed in that matter?
I have some TRND and ARC set to log to MS SQL db (ODBC). Maybe ARC (archives) numbering changed somehow? I remember it was quite confusing in previous version (in one place numbering was starting from 0, in other from 1..)

Describing my issue - I don't see any errors in logs in RexView, I see data on TRND and ARC objects but I don't see anything new in my database.

Maybe you have some ideas.

Regards
Hubert

jaroslav_sobota

Administrator

Registered: 2015-10-27

Posts: 535

Re: ODBC saving to database problem

Hi Hubert,
you are right, the numbering of archives was unified. All places use numbering starting from 1, therefore it is necessary to update your DB driver configuration. Please open the configuration dialog and set ArchiveID=1. Or change it directly in the .rio file.

Hope this helps, let me know.

Have a nice day,
Jaroslav

---

Monarco HAT for Raspberry Pi - Lightweight I/O for monitoring, archiving and control.
Raspberry Pi in industrial automation!

hubc

Member

Registered: 2016-09-05

Posts: 60

Re: ODBC saving to database problem

Hi!

Yes, after changing archive ids (now there are 1, 2...) it is working fine!
Thanks!

Hubert