Using Toad to connect to an DB2 iSeries database via ODBC but there's only one catalog entry to choose from within Toad
说明
Using Toad to connect to an DB2 iSeries database via ODBC but there's only one catalog entry to choose from within Toad.
原因
Toad uses the ODBC Data Sources Administrator for ODBC connections in Toad and which ever libraries are listed there will be listed in Toad. If only one source is available in the ODBC Data Source Administrator, then only one will be available in Toad.
解决办法
RESOLUTION:
Add more libraries in the Administrative Tools | ODBC Data Source Administrator to be available in Toad.