Category: English

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

Question: Can data be recorded in a remote Oracle or SQL Server? Solution: Yes; to do so, you must just enable the Oracle/SQL Server to accept remote data recording.

Question: If an application starts with an Access database and in the middle of the process it migrates to SQL/Oracle, will the previous data be sent to the new 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…