The following post assumes the following prerequisites have been satisfied:
A) Access to a dashDB server
B) Access to the dashDB web console
C) A client machine running the 64-bit version of Windows.
D) Be able to log into Windows as a local administrator or provide the credentials of a member of the local Administrators group.
Per IBM, the dashDB driver package contains several drivers. For example, Excel connects to the database by using the ODBC driver. Other drivers include CLI, JDBC, CLPPlus, .NET (Windows only), OLE DB (Windows only), PHP, Perl, Python, Node.js, Ruby, and more.
The Aginity Workbench for dashDB software uses a managed .net data provider to connect to a dashDB server. The data provider uses CLI, which is a core component of IBM software; therefore both the IBM Data Server Driver for ODBC and CLI package must be installed.
How to install the IBM Data Server Driver for ODBC and CLI driver package:
1) Download Driver package for Windows 64-bit by following the instructions from this web page:
2) Install the .exe file AS ADMINISTRATOR. This can be done by right-clicking the driver executable and choosing “Run As Administrator”. Choosing default install locations works well.
3) After installation of the driver completes, it is highly recommended to reboot the Windows machine.
4) Open the Windows ODBC Data Source Administrator Console in Windows and verify the IBM DB2 ODBC DRIVER and IBM DB2 ODBC DRIVER-IBMDBCL1 drivers have been installed properly.
This can be done by opening the Windows Control Panel -> Administrative Tools -> Data Sources (ODBC)
**NOTE** Failure to install As Administrator may lead to a partial install of the driver package. If this happens, you will likely see the IBM DB2 ODBC DRIVER - IBMDBCL1 driver. If this occurs, uninstall the driver package and reinstall AS ADMINISTRATOR. To uninstall you can use the Windows uninstaller.
Start -> Control Panel-> Programs and Features
Highlight the program called "IBM Data Server Package - IBMDBCL1" and click Uninstall.
5) After the IBM Data Server Driver for ODBC and CLI has been verified as installed, open the Aginity Workbench for dashDB and connect to the dashDB using the dashDB server address and login credentials supplied to you by your organization.
NOTE: If installing of 64 bit ODBC driver on Windows 7 fails without error (it displays a progress bar in a window that says "Extracting", and then closes without installing ODBC driver and no error messages are reported) :
See the IBM Technote here: http://www-01.ibm.com/support/docview.wss?uid=swg21700340
For more information please refer to the Aginity Workbench for dashDB documentation: https://www.aginity.com/documentation/wb/dashDB