- I would like to know if I can read and write Sqlite data base via SQL data type in mango
- if it is possible what is the driver class name and connection string
- If I install the sqlite database in RAM for fast access of data, still can I connect to that from Mango and how?
I am looking forward to establish Modbus TCP communication between OpenAPC software plc and Mango. However yet no any success.
In any case if this is not possible please advice me any opensource / free software plc that I can use for developing my my program and to use Mango as my HMI front end.
my requirement is as follows:
Modbus I/O Module <========> Software PLC <========> Mango M2M
Any response is highly valued.
I want to know that how to set up mango m2m to communicate with Ms Excel.
ie. my automation program is a n excel program (VBA) and I would like to use Mango as the modbus TCP gateway and Scada HMI.
for this reason I need to establish a communication between mango and excel for both data read and write.
I have done this previously with Siemens Desigo using Direct Data Exchange (DDE).
your support is highly appreciated
Great it did work !!
much appreciate the advise.
I think, I started using Mango M2M (the great Scada product) around 2010. My gratitude goes to the developers.
When I installed Mango on Windows it did work like a charm, but every time I tried installing on Ubuntu gave me a headache. finally I did manged to install on a Ubuntu server (I don't want to allocate more resources just for running a server)
The reason I want to install Mango on Ubuntu desktop version is the Gambas3 is another opensource SDK.
when I did some google research I found that ScadaBR which is a derivative from Mango M2M, but easy to install, and I can install it on Ubuntu desktop.
What soever I still love Mango M2M. much appreciate that if you can direct me to sort out the Mango Ubuntu installtion issue. I know this Forum is not for discussing installation issues.
Anyway thank you once again for helping me
Have a great day !!
thanks for the quick reply
I had a look into both documents you mentioned at the beginning.
my requirement is not to have entire mango data base on MYSQL.
I want to:
- setup MYSql data source In data sources. (this step is successful)
- I can update values into the MYSql database using update statement ,but I don't know that how to read a value from MYSql database into Mango (the statement)
I tried several ways eg:
typing "SELECT ......" statement inside the update query area (I may be silly because it self says that "Update statement"
without typing anything inside the query area.
nothing is successful. below is what I get
Your advice is highly appreciated
Hi I am trying to setup MySQL data base for reading and writing data point values.
So far I found the method to write data in to the MySQL data base (using "watch list") but I can not find a way to read data into "watch list".
when I press the statement test button ("Execute" button) in SQL properties page I can see my data. Please help me to configure this .
what I need is, using a Gambas3 program I will update or read a table in MySQL database (control or monitoring points). I want to use the same database and same data points in mango Scada to read or control
Thank you all