This is an old revision of the document!

Home menu > Application

Databases

This settings tab lists all databases known to Vigilens.

Add a database

SQL Language used

Vigilens natively supports the SQL language for the following platforms:

Access
DB2/400 except Union
DB2/Windows except Union
MySQL
Oracle
SQL Server

Data source

Oracle

For Oracle databases, connection is made through OCI, only TNS service name has to be provided.

In some machine configurations, the OCILIB library does not initialize correctly because the Windows user environment variables do not allow to locate the oci.dll file (present in the Oracle installation directory).

It is then possible to define this path via a registry key: HKEY_LOCAL_MACHINE\SOFTWARE\EVIDENS\Param\OracleLibPath.

ODBC

Otherwise, the connection is made through ODBC.

You must then choose (with the wizard) one of the ODBC connections defined either at the user level or at the system level. In most cases, we will use a system source.

In the case where the data source is not created in ODBC, you can access the windows ODBC setup by clicking ODBC data source setup button.

On 64-bit systems, it is advisable to use this button to access ODBC data source administration. This is because the application uses the 32-bit version of ODBC while the administration tools allow access to the 64-bit version.