When trying to connect to a live local DB2 database (DB2 LUW 11.1), I'm receiving the following error:
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).(IM003,160).
I do not have this problem on lower versions of Windows. Has anyone else experienced this issue or been successful in connecting to a live DB2 database on Windows 2016?
Do you mean Windows 10? I did have a problem accessing DB2 Z/OS 10 from a new Windows 10 laptop that was resolved by installing v11.1.2fp2b_ntx64_client.exe. We had this file on our network drive, you'll have to check with your DBA to find out where to get it from or see if you can download it from IBM.
Then I had to do the following - not sure how much of this was specific to my company, you may want to check with your DBA / Network Administrator: