Hi,
I've been working with Citect SCADA since 2006 and i've been using versions from 6.0 to 2016. I've done projects with writing and reading data from MySQL and MsSQL. For MySQL i used to use ODBC connection, but latelly I worked more with MsSQL.
I can send you some cicode examples.
I would like to get more info about your project.
Kind regards,
Ales Bezeljak