Category: DataBases

This article will show you how to install and set up a Firebird database connected to Elipse E3 via ODBC.First of all, you will need to download the installer. Then,…

Autor
Bruno Musarra

To create an ODBC connection with SQLServer, follow these procedures: Windows: 1. Go to Control Panel: 2. Access Administrative Tools: 3. Access Data Sources (ODBC): 4. On User DSN tab,…

Question: When Elipse SCADA is open, why can’t I open the linked database? Solution: The database opening mode via ODBC connection is usually exclusive, that is, it prevents the simultaneous…

Question: After having formatted the computer and correctly installed Elipse SCADA, the application being executed displays the following error message:  “The DAO.dll file was not found “. How can I…

Question: How can I record tag values in an Access database’s table? Solution: To do so, you must first create an Access database with a table. Then, create an ODBC…

Question: When I click Databases via Organizer, the following message is displayed: “This resource is not available for this version of Elipse SCADA “. Why does this happen? Solution: This…

Question: How can I search for dates with SQLQuery function? Solution: To do so, the comparison value of Date/Time field must be between  “#” signs, as seen below: SQLQuery(“DateTime =…

Question: Do I need to use a database to create a registry system in the application? Solution: No. There is already a proper place in Elipse SCADA to store information…

You can use an ODBC connection to export/import/change data from an external database’s table via Elipse SCADA. In the attached demo application, there are connections for Microsoft Excel 97, Microsoft…