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,…

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,…

Autor
Bruno Musarra

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…