ODBC System DSN does not show up in cnnection’s Source/Destination tab

Created: 2012-04-20 08:09:59
Modified: 2017-06-04 15:18:22
Tags: ODBC UnitySync

If your ODBC DSN does not show up in the UnitySync connection Source or Destination tab drop-down menus, you have likely created the DSN on the wrong version (32-bit vs 64-bit).

As of UnitySync v2.1, ODBC connections require the use of 64-bit ODBC DSN’s. Previous UnitySync versions required 32-bit ODBC DSN’s.

If you are running v2.1 or greater and creating a new ODBC connection, Go to Control Panel > Administrative tools to start ‘ODBC Datasources 64-bit’. Create the System DSN for your database using the appropriate ODBC driver. Once created, the DSN should now appear in your UnitySync connection Source or Destination tab.

If you are upgrading an existing ODBC connection from a version v2.0 or earlier, the existing ODBC DSN would likely have been created with 32 bit ODBC. The latest version of UnitySync requires the use of 64-bit DSN. When looking at the old connection in the new v2.1+ UnitySync, the Source or Destination tab will not show the 32-bit DSN in the drop down list. You will need to recreate the ODBC DSN with 64-bit ODBC. Go to Control Panel > Administrative tools to start ‘ODBC Datasources 64-bit’. Recreate the System DSN for your database. The DSN should now appear in your UnitySync connection.

If you are running a version prior to UnitySync v2.1: Prior to v2.1, UnitySync required the use of a 32-bit ODBC DSN. If you are running UnitySync on a 64-bit OS, you have the option to create a 32-bit or 64-bit ODBC DSN. The instructions below explain how to specifically create a DSN using 32-bit ODBC which is required for the older version of UnitySync.

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

UnitySync uses the 32-bit version of ODBC. This requires the 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. Then return to UnitySync. You should see the DSN is now available.

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

Share this article:
Knowledgebase

Directory
  1. Directify - Self Service

  2. Mimic - Replication

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