Features, discussions, tips, tricks, questions, problems and feedback

HistoricalAlarmViewer and MySQL ODBC Connection

Hello,
I use a HistoricalAlarmViewer and I try to connect to mysql ODBC datasource but I get the following error
Exception Data:

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
maps_scada_serialization_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.