Question: After configuring the fields, the data server (Access), and table name in a historic, I click Generate Table and the following error message is displayed:    Table structure (title of…

Question: When I open the Viewer or WebViewer and click on a button that executes a script to query an Oracle database, a connection error to the database is generated.…

Question: How can I copy data from an Excel spreadsheet to an Access database? Solution: There are two possibilities: At runtime: With a script using an ADO connection to access…

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…