Can’t Find Created ODBC Connection

After creating an ODBC connection, you may find that you are not able to locate the ODBC connection when mapping to UPS WorldshipFedEx Shipping Workstation or creating a Microsoft Excel Query. In Windows, there are two ODBC Data Source Administrators: a 32-bit and a 64-bit variant.

The ODBC Data Source Administrator can be located in the Control Panel under the Administrative Tools section. The ODBC Administrator you see here is set to the same bit version of windows. Simply put, on 64-bit windows you will see the 64-bit Administrator and on 32-bit Windows you will see 32-bit Administrator.

Many programs still use the 32-bit variant, so if you are running a Windows 64-bit machine, you may need to launch the ODBC Data Source Administrator from C:\WINDOWS\SysWOW64\odbcad32.exe. Once you create the ODBC connection here, it will be visible to select in the program that needs to be connected to the Acctivate database.

Posted in Database - Last modified on February 22, 2016
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support ticket.