In Toad 8.0, when using Client CFG connections, there is an issue with the way Toad looks for the db2dsdriver.cfg file. When you try the Client Cfg → DSN Collection connection method, there is an error written in red in Toad:
"Config file path: No configuration file found for client DB2COPY1"
This happens because:
- The default location for the db2dsdriver.cfg file is in ProgramData:
C:\ProgramData\IBM\DB2\driver_copy_name\cfg
(https://www.ibm.com/docs/en/db2/11.5.x?topic=file-data-server-driver-configuration-location)
- Toad will currently only find the db2dsdriver.cfg file, if it is manually copied from the default directory above, to the DB2 client installation folder, such as C:\Program Files (x86)\IBM\SQLLIB\cfg or C:\Program Files\IBM\SQLLIB\cfg
- Even if a Windows environment variable 'DB2DSDRIVER_CFG_PATH' is created to point to the db2dsdriver.cfg file in the default location, it works for other Windows/ODBC applications, but the variable is ignored in Toad.
Product Defect TDB-4624
WORKAROUND:
Manually copy the db2dsdriver.cfg file from C:\ProgramData\IBM\DB2\driver_copy_name\cfg to the DB2 client installation folder, e.g: C:\Program Files (x86)\IBM\SQLLIB\cfg
STATUS:
Waiting for fix in a future release of Toad for DB2
