10 Replies Latest reply on Apr 30, 2018 8:15 PM by Nathan Panuco

    Uhm, huh?  Prep can't connect to data source even though Desktop can

    Toby Erkson

      I get this error when I try to connect to our DB2 data source in Prep:

      Here's the full text:

      An error occurred while communicating with IBM DB2.


      Detailed Error Message

      Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (IBM DB2 ODBC DRIVER, C:\Program Files\IBM\SQLLIB\BIN\DB2CLIO.DLL).

      Unable to connect to the server "*******". Check that the server is running and that you have access privileges to the requested database.


      What doesn't make sense is that Tableau Desktop (10.5) connects just fine.  Both applications are on my laptop and the DB2 setup has been on my laptop and working for several months.  I haven't installed the Tableau drivers because that will set up another directory because the version, IBM 10.5 for Prep, is behind our enterprise version of IBM 11.0.