Versions: all CranSoft and DSP versions
Problem:
Error received on testing connection in System Administration / DataSources:
"Connection test failed. A connection could not be established with the underlying data source. The 'IBMDADB2' provider is not registered on the local machine."
(A different provider name might also be seen.)
Root cause:
The driver is not installed, not installed properly, the system has not been rebooted, or the wrong version of the driver has been installed.
Solution(s):
1. Install the 32-bit version of the relevant driver on the CranSoft/DSP App server. In the case of the above error, this would be the DB2 client driver.
2. Reboot the App server post installation.
3. If the wrong version of the driver has been installed, remove it, reboot, then install the correct version and reboot.