Skip to main content
InSource Solutions

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.

  • Was this article helpful?