How to connect to a database source using ODBC

SYMPTOMS

Using ODBC as the connection method, select a Data Source Name (DSN).

A DSN is a data structure that contains the information about a specific database that an Open Database Connectivity (ODBC) driver needs in order to connect to it. It is created beforehand via the ODBC Data Source Administrator program. Included in the DSN is information such as the name, directory and driver of the database, and depending on the type of DSN, the ID and password of the user.

In order to proceed define the appropriate connection method and choose the DSN option.

CAUSE

Not applicable.

RESOLUTION

To enable a proper connection make sure that the Database Fields module is selected.
Select Database Connection Wizard in Step 5 of the index wizard.
The Database Settings Wizard appears.

The wizard allows you to connect ZyINDEX to ADO in order to access/manage data through an OLE DB Provider, ODBC or native provider.
The ZyINDEX Ado.xml file enables the link between the ZyINDEX index(es) and the type of database that is being used.

APPLIES TO

6.0; 6.1; 6.2; 6.2 Service Pack 1; 6.2 Service Pack 2; 6.3