Managing Data Sources

• ODBC Driver Architecture & 64-bit Windows versions
• Adding a new Data Source
• Modifying a Data Source
• Removing a Data Source
• Data Source settings

ODBC driver architecture & 64-bit Windows versions

The ODBC client setup installs both 32- & 64-bit drivers on your system. The 64-bit driver is only compatible with 64-bit applications such as the 64-bit version of Microsoft SQL Server. However, most applications, like those that make up the Microsoft Office suite, are 32-bit.

The Control Panel's Data Sources (ODBC) applet on 64-bit versions of Windows will only manage 64-bit drivers. To manage 32-bit drivers you will need to run the 32-bit version of the ODBC Administrator from a DOS prompt. Run cmd.exe as a user with Administrative privileges.

C:\> cd %windir%\SysWow64
C:\> odbcad32.exe

Adding a new Data Source

Before you can access data with the KCML ODBC driver, you must create a data source for it. The KCML ODBC driver uses the information you enter to access the data. You can change or delete a data source at any time.

From the Windows Control Panel, choose Administrative Tools -> Data Sources (ODBC) or when creating a data source that requires a different architecture run the odbcad32.exe command from a DOS prompt; see ODBC driver architecture.

This produces the ODBC Administrator main dialog displaying the data sources currently defined. If the dialog is empty then there are none defined for the currently logged in user. Data sources can also be defined for the system independent of user by clicking the System DSN tab.

Microsoft ODBC Data Source Administrator, odbcad32.exe

To add a data source

In the Data Sources dialog box, choose the Add button. This will display the list of ODBC drivers that are available:

32-bit odbcad32.exe	64-bit odbcad32.exe

In the Add Data Source dialog box, select the appropriate KISAM Driver from the Installed ODBC Drivers list and choose OK. This will now display the KCML ODBC Setup dialog box. Enter information to set up the data source as described below.

To modify a data source

• In the Data Sources dialog box, select the data source from the Data Sources list by highlighting it using the arrow keys.
• Choose the Setup button.
• This will now display the KCML ODBC Setup dialog box. Enter information to set up the data source as described below.

To delete a data source

• In the Data Sources dialog box, select the data source from the Data Sources list by highlighting it using the arrow keys.
• Choose the Delete button, and then choose the Yes button to confirm the deletion.

Filling in the setup dialog

Click on the parts of the box below where appears for explanations of the fields