Skip to main content
InSource Solutions

TN IT133 Connecting InTouch to a database on 64bit OS using ODBC

insource logo large.jpg

 

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.