Connections between E3 and Database.
For each DBServer created in an E3 domain, there are two possible connections with the Database: one of them is used for E3 services (Formulas, Historics, Storage, and Alarms), and…
Category: DataBases
KB-33906: Hot-Standby x Databases.
Question: What is the proper architecture to work with databases in Hot-Standby? Solution: There are two possibilities: Two computers running E3Server (Hot and Standby), and a third one running the…
KB-47068: Recovering file generated as backup in an SQL database.
Question: After SQL database’s backup has been performed, how can I recover the generated .BAK file? Solution: To do so, follow these procedures: 1. Open Management Studio. 2. Click New…
Connecting E3 to a remote Access database.
Question: Can E3 connect to an Access remote database? Solution: Yes. To do so, Access’ .MDB file must be in a shared folder on the network. To create a shared…
Connecting PostgreSQL database via network.
Question: Can I connect to a PostGreSQL database via network? How should I set this up? Solution: Yes, you can. To do so, you must follow these guidelines: Server: Install…
Creating an ODBC connection manually.
Foreword: This example uses the Microsoft Access database, but with ODBC you can connect to any existing database that has an ODBC driver installed on your computer. 1. In case…
Installing Oracle 11g Database.
Introduction The goal of this article is to clarify a few questions about Oracle’s installation and its many different available modules. Differences between Oracle 10g Express Edition and Oracle 11g…
Using Databases in E3: Chapter 5 – Inserting Records.
There are two ways to insert new records in a database in addition to using native E3 objects: via a Query or via scripts. If record insertion is performed via…
Using Databases in E3: Chapter 6 – Editing Records.
To edit a record of the Historic, you must use the UPDATE clause. This is the SQL code structure. UPDATE (function used) TABLENAME (table used) SET FIELDNAME2 (field of the…
Using Databases in E3: Chapter 7 – Deleting Records.
Records can be deleted in two ways: by filter, or by all existing records. To delete only one or more records of a database table, you must configure the SQL…