ODBC text setup

The ODBC text setup dialog is used to configure the ODBC driver for a text based database.

In this window we need to set several items:

Data Source Name

This just a name for the setup you are making, name this Radimation, or another descriptive name for the used database

Select Directory...

Allows to select the directory in which the text based database files are stored

Use Current Directory

Overrules the selected directory to use the current directory. It is best to turn this checkbox off, and select a specific directory by using the Select Directory... button

Extensions List

Shows a list of filename extensions which will be used to determine the correct text files. Remove *.asc and *.tab from the extentions list

Define Format...

Will show the Define Text Format dialog, which can be used to define the format of the database as it is maintained in the text file

Select the file you want to use, check the Column Name Header checkbox and select the format. Press Guess button to see if the column headers from your database are set correctly. In the screenshot above the columns are not set correctly. The .csv file format is different, to solve this press the Format combobox and select Custom Delimited. Insert ';' in the delimiter textbox and press Guess again.

Now everything is set correctly, close all windows by pressing the Ok button on every window. Once the ODBC Data Source connection is correctly configured, the configuration of the [[customer database