To store reports in a database, configure the database in the Preferences. First, select the Provider, which determines the settings based on the selected format. Choose the database type used in your system. In the "SQL Schema" subfolder of the AIDA64 Business folder, you will find eight database schema files (the ninth supported format, ODBC, does not require a schema file).
Provider and database schemas
If not using Access, initialize SQL database table layouts using the appropriate “DB - .” files from the SQL_Schema folder.
- DB - Access.mdb: For MS Access 2000/XP/2003/2007
- DB - Access97.mdb: For MS Access 97
- DB - InterBase.sql: For Borland InterBase and Firebird
- DB - MySQL.sql: For MySQL
- DB - Oracle.sql: For Oracle
- DB - PostgreSQL.sql: For PostgreSQL
- DB - SQLServer.sql: For MS SQL Server
- DB - Sybase.sql: For Sybase
Server
Specify the name or IP address of the SQL server. If needed, specify a server port.
Database
Enter the database name or, for MS Access, the location of the Access database file. Authentication information is required for AIDA64 to read the database list from the server.
Driver
Select the appropriate driver. Install it if it is not already installed.
Windows authentication
Enable this option to authenticate the current user on the SQL server using their logon credentials. Ensure users have write permissions to the database.
Test button
Press the “Test” button to test the SQL connection configuration. This performs only a connection test; no tables are created, and no records are inserted.
