System DSN does not appear in ODBC Connection tab - pre UnitySync v2.1 and Windows 2008

Created: 2012-04-20 08:09:59
Modified: 2022-01-10 09:33:03
Tags: ODBC UnitySync

Note: This article is relevant for versions prior to v2.1 but does not apply to current versions of UnitySync.

On your Windows 2008 Server, when running Admin Tools > Data Source (ODBC), this runs the 64-bit version of the ODBC Data Sources.

If you create a 64-bit ODBC Data Source, it will not show up in a UnitySync connection (UI Source and Destination tab DSN drop-down boxes).

UnitySync versions prior to v2.1 use the 32-bit version of ODBC. You must create a 32-bit ODBC Data Source.

  • This requires that Oracle client be installed first
  • Then, on the Windows 2008 Server, go to a cmd prompt and run odbcad32.exe
    %systemdrive%\Windows\SysWoW64\odbcad32.exe
  • Recreate the desired System DSN here
  • Then return to UnitySync and you should see the DSN is now available

Reference this article for details regarding 32 vs 64 bit ODBC: http://robertoschiabel.wordpress.com/2008/02/28/windows-x64-32bit-odbc-vs-64bit-odbc
Knowledgebase

Directory
  1. Directify - Self Service

  2. Mimic - Replication

  3. UnitySync - Sync
Password
  1. emPass - Sync
Obsolete
  1. Profiler
  2. SimpleSync