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).

Explanation:

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.


MS SQL Server (SQLOLEDB)

More...

MySQL (MSDASQL) / MariaDB

More...

Borland InterBase / Firebird (MSDASQL)

If we use an InterBase or Firebird database, we can specify a data source, although this is not required. We need to specify the server name or IP address and the port required for the database connection, then select the database and the driver. We can also add a user name/password combination or choose Windows authentication.

If we want to save the reports to a Borland InterBase database, it is necessary to install the InterBase Client and an InterBase ODBC driver on all networked computers. If we want to save the reports to a Firebird database, it is necessary to install the Firebird Client and a Firebird ODBC driver on all networked computers. For example, Easysoft ODBC drivers for InterBase and Firebird can be purchased at http://www.easysoft.com.

MS Access 97 (MS.Jet.OLEDB.4.0)

If we use MS Access 97, we need to specify the path for the database only, which is found in the “SQL_Schema” folder. We have to copy this file to a share which clients can modify, and select this file. We have to make sure to specify a remote path if we use a central database. Here we can also specify our user name and password required for the connection.

Using MS Access is recommended for testing purposes only because it only allows a single computer to fully access a given Access file. It is not necessary to install MS Access on the computers.

MS Access 2000 / XP / 2003 (MS.Jet.OLEDB.4.0)

If we use MS Access 2000 / XP / 2003, we need to specify the path for the database only, which is found in the “SQL_Schema” folder. We have to copy this file to a share which clients can modify, and select this file. We have to make sure to specify a remote path if we use a central database. Here we can also specify our user name and password required for the connection.

Using MS Access is recommended for testing purposes only because it only allows a single computer to fully access a given Access file. It is not necessary to install MS Access on the computers.

Oracle (MSDAORA)

If we use an Oracle database, we need to specify the server name or IP address and the port required for the database connection, then select the database. We can also add a user name/password combination or choose Windows authentication.

If we want to insert reports to an Oracle database, it is necessary to install the Oracle Client on all networked computers. It can be found on the Oracle installation CD.

PostgreSQL (MSDASQL)

If we use a PostgreSQL database, we can specify a data source, although this is not required. We need to specify the server name or IP address and the port required for the database connection, then select the database and the driver. We can also add a user name/password combination or choose Windows authentication.

When PostgreSQL is selected, it is necessary to install PsqlODBC on all networked computers. PsqlODBC can be downloaded from http://pgfoundry.org/projects/psqlodbc .

Sybase (SybaseASEOLEDBProvider)

A Sybase adatbázis használatához beállíthatunk adatforrást, de ez nem szükséges. Adjuk meg a kiszolgálónk nevét vagy IP-címét, majd válasszuk ki az adatbázisunkat! Megadhatjuk egy felhasználó nevét és jelszavát, valamint használhatunk Windows-jelszóhitelesítést.

Amennyiben a riportokat Sybase adatbázisba szeretnénk elkészíteni, akkor telepítsük a Sybase ASE ODBC-illesztőprogramot az összes hálózatba kötött számítógépre a telepítő CD-ről!

ODBC (MSDASQL)

If we use a different database listed in the provider list and have an ODBC driver available for it, it is possible to use that database, too.