TN IT133 Connecting InTouch to a database on 64bit OS using ODBC
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
- Published: 05/29/2015
- Applies to: InTouch 10.1 and up, on Windows 64bit
Details
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.