Database
If we store reports in a database, we need to configure the database in the Preferences menu. First, we have to select Provider, and all other settings are then dependent on the selected format. We have to choose the database type we use in our system! In the “SQL Schema” subfolder of the AIDA64 Business folder we can find 8 database schema files (the ninth supported format, ODBC, does not require a schema file).
Provider and database schemas
If we do not use Access, SQL database table layouts need to be initialized using one of the “DB - *.*” files found in the SQL_Schema folder.
- DB - Access.mdb – Database file for MS Access 2000/XP/2003/2007
- DB - Access97.mdb – Database file for MS Access 97
- DB - InterBase.sql – Schema for Borland InterBase and Firebird
- DB - MySQL.sql – Schema for MySQL
- DB - Oracle.sql – Schema for Oracle
- DB - PostgreSQL.sql – Schema for PostgreSQL
- DB - SQLServer.sql – Schema for MS SQL Server
- DB - Sybase.sql – Schema for Sybase
Server
We need to specify the name or IP address of the SQL server. If required, we can specify a server port as well.
Database
Here we can specify the database name or, if we use MS Access, the location of the Access database file. We will first need to add authentication information so that AIDA64 can read the database list from the server!
Driver
Here we have to select the appropriate driver. If it is not installed yet, we have to install it first!
Windows authentication
When this option is enabled, the actual user is authenticated on the SQL server using his/her current logon credentials. We need to ensure that we grant write permission to users of the database.
Test button
We can test the actual SQL connection configuration by pressing the “Test” button. Only a connection test is performed, no tables are created and no records are inserted during the test process.