In Toad 8.0, Client Cfg | DSN Collection connection option, Toad shows the error "Config file path: No configuration file found for client DB2COPY1". (4379489)

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