Category: DataBases

Question: How can I set up an SQLExpress database in an E3 application? Solution: To do so, you must first install the SQLExpress in a PC, create a database, and…

Question: How can I access (directly in the database and not via E3) the Stored Procedures E3 has created with Storage in Oracle? Solution: The Stored Procedures are in the…

Question: I have configured a database with SourceType property as 2-stSqlServer, and set up a user and a password according to the SQL Server. When I add a query to…

Question: How can I tell whether the remote database is available when the network is down? Solution: To do so, use a script to test the Database’s ConnectionAtive property. However,…

Question: What Databases are supported by E3? Solution: E3 is natively connected to Access, Oracle, SQL Server, PostgreSQL and MySQL.. However, if you want to connect to another database, this…

Question: In a 64-bit server, I have a 32-bit E3 and a 64-bit Oracle Client installed. When I test their connection in E3Studio, the following message pops up:           It…

This article illustrates how to set up a connection to an SQL Server database in E3, as well as recording data and applying queries for being viewed on screens. For…

1) Introduction This articles discusses a few specificities of how Elipse E3 works with Oracle. We do not show how to setup Oracle databases here. This should be conducted by…

Introduction Sometimes, when an E3 application performs many operations on a database, even when the application is working properly, some information may not be not recorded, or E3Chart or E3Browser…