Question: Should a data structure be created beforehand (for example, a table in the SQL Server) so that I can start working with the Database in E3? Solution: Not necessarily.…

Question: What can cause an Oracle database to run slower (in Queries or when inserting and deleting data), and yet not presenting any other apparent errors? Solution: This could be…

This article illustrates how to install and set up the SQL Server Express 2005, free version of Microsoft’s database, and use it as E3’s database. The installer can be downloaded…

Question: Why are _Sync.e3i and _Sync.e3o files being created in the application folder of the computer running E3? Solution: These files contain database operation queues that are being synchronized between…

Question: How can I format a value containing zeroes to its left and then later save it in a historic? Solution: To add zeroes to the left, use the following…

Question: How can I set up an Oracle database in the same computer running E3Server? Solution: To do so, just leave Connection field blank in the database settings. You will…

Question: How can I connect to an INFOMIX database via scripts? Solution: To connect to an INFOMIX database via scripts, you can use the following methods: Set DBConnection = CreateObject(“ADODB.Connection”)…

Question: How can I back up a database via E3? Solution: To do so, there are two possibilities: 1. In an Access database, copy the file corresponding to the database…

Question: How can I establish communication between E3 and SQL 2005 Express ? Solution: To do so, add a database to E3, access its properties, and set it up as…

Question: What is a Database Server? What is it for? Solution: A DBServer, or a Database Server, is the application item that concentrates all the project’s data records and queries…