Demo application: Elipse SCADA interaction with a database via DAO connection.
Attached to this article is a demo application that illustrates how to use a database via DAO connection. Attachments: DAO218.zip
Attached to this article is a demo application that illustrates how to use a database via DAO connection. Attachments: DAO218.zip
Access to Elipse SCADA’s database can happen via ISAM or ODBC sources. ISAM Connection ISAM is not supported by Windows x64, only x86, and as long as ISAM connection drivers…
Question: When creating an ODBBC source in Windows 64 bits, not all drivers are listed, nor can I establish communication with the ones that do appear on the list. How…
Foreword: This example uses the Microsoft Access database, but with ODBC you can connect to any existing database that has an ODBC driver installed on your computer. 1. In case…
The first step is to set up an Excel spreadsheet to work as a database. To do so, create a new work folder and, at a certain point on the…
Question: Can Elipse SCADA be connected to an Oracle database? Solution: Yes. To do so, you will need to use an ODBC connection. For further information, see the related article…
Question: Which function should I use to delete a record in a database? Solution: To do so, you need to use the DeleteRecord() function.
Autor
Mateus Machado
Question: Can I connect SCADA to the SQL Server? Solution: Yes. To do so, you must use an ODBC connection. For further information, access Tutorial for creating an ODBC connection…
Question: How can I create a filter for an SQL Server’s query with an ODBC connection? Solution: To do so, you must use table’s SQLQuery() function. Records can be selected…