Icon Configuring a Data Source

Introduction
A data source, or DSN (Data Source Name), is used by applications that use ODBC to locate and access a specific database in a specific location. Once you have configured a data source in the ODBC Administrator, you may use this data source name in any application that can access ODBC. However, you should check out the Application Compatibility notes in this manual for more information on applications that have been specifically tested with the DBISAM ODBC Driver.

Step-By-Step Instructions
Complete the following steps to properly configure a data source that uses the DBISAM ODBC Driver:

1) Run the ODBC Administrator (odbcad32.exe). This program is located in the Start menu under Programs/Administrative Tools/Data Sources (ODBC).

Information By default, 32-bit versions of Windows use the 32-bit ODBC Administrator, and 64-bit versions of Windows use the 64-bit ODBC Administrator, when launching the ODBC Administrator via the Administrative Tools link. If you're using a 64-bit version of Windows, then you must use the 32-bit ODBC Administrator located here in order to configure 32-bit data sources for use with 32-bit applications and the 32-bit DBISAM ODBC Driver:

<WindowsInstallDir>\SysWoW64\odbcad32.exe

where <WindowsInstallDir> is the base Windows installation directory, usually c:\Windows.

2) If you want the data source to be accessible by all users, then click on the System DSN tab. If you want the data source to only be accessible to the current user, then click User DSN tab (the default page).

3) Click on the Add button to begin adding a data source. This will bring forward a dialog with a list of the installed ODBC drivers. Select the DBISAM ODBC Driver from the list and click on the Finish button.

Information It is possible that there may be more than one DBISAM ODBC Driver listed due to multiple, different major versions of the driver being installed on the system.

4) A DBISAM ODBC Driver configuration wizard dialog will now be shown. Follow the instructions on this wizard to complete the data source configuration.

If at any time you wish to re-configure the data source, simply choose the appropriate tab page (User DSN or System DSN), select the data source name that you previously added from the list of data sources, and then click on the Configure button. This will bring forward the same configuration wizard dialog as before, except in this case you cannot specify a name for the data source.
Image