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 can be done by creating an ADO connection via scripts. In this case, you will not be able to use the E3Query object, and consequently neither E3Browser, E3Chart, and Reports. So, using a different database will require extra work and give you limited results.
In case you are looking for a free database, you can use Oracle’s or SQL’s free versions.
NOTE: attached to this article, there is a demo application that shows how to get data from an Excel spreadsheet creating an ADO connection via scripts.