Your computer has two ODBC Data Source Administrator Tools - one for 32-bit applications and one for 64-bit applications. If you are using a 32-bit application on your computer, you need to use the 32-bit ODBC Data Source Administrator Tool to set up ODBC access.
To access the 32-bit ODBC Data Source Administrator Tool:
Either:
-
In the Search field in Windows, enter the following search string: Control Panel.
The Control Panel is displayed. -
In the Search field in the Control Panel, enter the following search string: ODBC.
Results for the two ODBC Data Source Administrator Tools are displayed.
-
Select the option for the 32-bit ODBC Data Source Administrator Tool.
or:
- In Windows, execute the following command:
%WINDIR%\SysWOW64\odbcad32.exe
For information on how to execute a command in Windows, please refer to your Windows documentation.
Either procedure will cause the 32-Bit ODBC Data Source Administrator Tool to run.
Use the Add button if you need to add a new ODBC data source:
Use the ODBC Data Source Administrator Tool to set up ODBC access Configure the ODBC DSN Settings.