Category: DataBases

Why are .e3i and .e3o files too big? These files are temporary buffers, which are not usually noticed by the user of the system. When they grow in size, this…

To establish a connection with a database in E3 using the Organizer, first you must create a Database object, according to the following figure: Figure 1: Inserting a Database object…

In order to send records to a database, you must insert a Historic object. A tutorial for creating Historics can be found in the article http://kb.elipse.com.br/pt-br/questions/123. Figure 1: Inserting a…

The Query’s GetADORecordSet method returns a Recordset object of type ADO (ActiveX Data Object), the result of executing the configured query. The ADO RecordSet object is used to access records…

One of the best resources available in E3 is the possibility of database connection. E3 is ready to connect to Access, Oracle, SQL Server, PostgreSQL and MySQL databases. In this…

Choosing a database directly depends on its purpose. Next, there is a comparison among the advantages and disadvantages of the available database. Access Advantages Fast for small databases; Simple configuration.…

Question: Even when configuring a SQL Server database as ComputerName\SQLEXPRESS, there is a need to repeat this configuration every time the machine changes. Is it possible to set up the…

This article will show you how to install and configure the PostgreSQL Database step by step, in order to use it with E3 via ODBC connection. To do so, you…

Question: How can I connect Elipse E3 to a PostgreSQL database? Does it have native support to this database, or do I need to perform any extra procedures to do…