System.Exception: An OLE DB Provider was not specified in the ConnectionString. An example would be, ‘Provider=SQLOLEDB;’.
Please see the attachment images below
MAPS version [4.0.5.3 32bit] (HMI mode)
Thank you in advance for your help.
Odbc won’t work with historical alarm viewer, it can only be full-fledged OLEDB to Microsoft SQL database
Damiand thank you for your quick reply.
Now i am trying to Binary Serialize the AlarmViewer control by i get the following error
Any idea?
Not sure what are you trying to achieve, but indeed alarmviewer was not designed as serializable class
For my scada application i use MySQL DB server and i write a script for saving the agents values without any problem. So far so good. The problem is with the alarm history because historical alarm viewer support only the MS SQL database.
I want to ask you if there is an alternate way to store the alarms, because it is time very consuming to change from MySQL to MS SQL.
Thanks again.
Serializing a UI object directly into a database does not make sense. You may be overcomplicating things here.
To save agent values you do not need a script, if you have an ODBC compatible data source you can use the DBAccess agent. Refer to: MySQL and methods of accessing it in MAPS/SmartUI - SmartUI - Features, discussions, tips, tricks, questions, problems and feedback (adroittechnologiesautomation.com)
To store alarms in an ODBC compliant database, refer to the Postgres example: PostgreSQL and methods of accessing it in MAPS/SmartUI - SmartUI - Features, discussions, tips, tricks, questions, problems and feedback (adroittechnologiesautomation.com)
Off-course, Microsoft SQL is strongly supported out of the box without the requirement for any of the abovementioned workarounds (with support for the free version as well - Microsoft SQL Express)
