-
Title
Does Toad support using DB2CLI writecfg commands to add to the Catalog connections? -
Description
In Toad 7.4.1, if you use a DB2CLI Writecfg command to try and add a connection via the DB2 Command Window, it is added successfully in DB2, but doesn't appear in the dropdown menu in the connection screen in Toad.
The following example is successfully added, (but not shown in Toad):
db2cli writecfg remove -dsn SAMPLEDB
db2cli writecfg add -dsn SAMPLEDB -database SAMPLEDB -host hostname -port 12345
db2cli install -setup
db2cli registerdsn -add -dsn SAMPLEDB -system -
Cause
Toad for DB2 7.4.1 does not support using db2cli writecfg entries in the Catalog dropdown.
The behavior of not seeing the connections in the dropdown menu is expected. Only databases cataloged using DB2 CATALOG commands are visible under Catalog connections. -
Resolution
Support for recognizing DSN's from db2dsdriver.cfg was implemented as a feature in Toad for DB2 version 8.0, available to download here
To see DB2CLI Data Source Names (DSNs), please upgrade to Toad for DB2 8.0, and use the Client Cfg → DSN Collection connection method.