BarTender Crashes When Attempting to Connect to an IBM DB2 Database
Symptom
When trying to connect to an IBM DB2 database using the Database Connection Wizard, the following error appears, causing BarTender to crash.
Environment
BarTender 2016 and later
IBM Data Server Driver Package v11.1
Solution
This error is caused by an installation issue for the IBM Data Server Driver version 11.1. After installing the 11.1 version the system environment variables are not getting updated correctly. Follow these steps to resolve the issue:
- Open a Command Prompt with Administrator rights. Do this by right-clicking on the Command Prompt icon and selecting Run as Administrator.
- Navigate to the correct folder using the cd command. The file path is C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin.
- Run the command db2switch. The IBM Database Client Interface Wizard will open up and complete with the default options.
- You will now be able to successfully connect to your IBM DB2 database in BarTender.