Connecting InTouch to a database on 64bit OS using ODBC
 | |
| Internal Use Only |
Description
When connecting between InTouch and a database (Access/SQL/Etc) you often use a DSN created in Windows ODBC to make the process simpler. When doing this with a 64bit OS, you will run into problems unless the 32bit version of ODBC is used.
| Author | Dillon Perera |
| Publish Date | 9/16/2014 |
| Applies to Software | InTouch Classic, InTouch for System Platform |
| Applies to Version | All versions |
| Applies to System/Module | |
| Article Version | 1.0.0 |
***********************************************************************************************************************************************Tags recommended by the template: stage:review
Pre-Requisites
This tech note only applies to installations of InTouch which are installed on a 64bit Windows Operating System. If using a 32bit version of the Windows Operating System the location of the ODBC executable will be different, but all other steps for configuring your connection will be the same.
Detailed Steps
Typically when setting up a Data Source Name (DSN) in Windows you would go to Control Panel > Administrative Tools > Data Sources (ODBC). Because InTouch is a 32bit application, it will attempt to connect to the 32bit version of ODBC. If using a 64bit Windows Operating System (ex: Windows 7 Pro 64bit), if you perform the above steps to open Data Sources (ODBC) it will actually open the 64bit version and not show options for a 32bit version.
To access the 32bit version of ODBC you would need to open it directly from the harddrive. This can be found in:
%SystemDrive%\Windows\SysWoW64\Odbcad32.exe.
In most installations this will be C:\Windows\SysWow64\Odbcad32.exe
The 64bit version of ODBC, which is what is found in Control Panel > Administrative tools is located in:
%SystemDrive%\Windows\System32\Odbcad32.exe
Note: Both the 32 and 64bit versions of the file have the same name, the only identifying difference is their location on the harddrive.