Skip to main content
InSource Solutions

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

insource logo large.jpg



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




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:

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:


Note: Both the 32 and 64bit versions of the file have the same name, the only identifying difference is their location on the harddrive.