How to Install the Necessary Drivers for Aginity Workbench for dashDB

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 ADMINISTRATORThis 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:

For more information please refer to the Aginity Workbench for dashDB documentation:

Have more questions? Submit a request


  • 0
    Ray Canuel

    This is very useful.  Aginity-->nonSSL-->DashDB is working nicely.

    It seems challenging to get the SSL connection to work.   I check the SSL connection and it fails.  Error 42724.    I have copied and even created a new connection with SSL checked.  Same failure.  It seems Aginity does not connect to the DSN created within Control Panel.  I have that working for SSL.


    My steps:

    1)      Login to dashdb.  Go to Connect.  Download the SSL certificate

    2)      From the file manager, open the ssl certificate.  Choose all defaults.

    3)      Edit the dashdb_configure.bat script with notepad.

    4)      Find/replace 50000  to 50001 everywhere.

    5)      Save as dashdb_configure_SSL.bat

    6)      dashdb_configure_SSL.bat <hostname from dashdb connect page>

    7)      Go back to Control panel-->ODBC-->dashdb-->Configure <Advanced tab> Add “security” = ssl.

    8)      Test connection.  SUCCESS.

  • 0
    Dan Gasperut

    One note for this, if you are not an admin you probably don't have Setup in your dash db menu. The drivers are available under the Connect > Download Tools option as well. 

Please sign in to leave a comment.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Powered by Zendesk