-
Title
Database Browser is not displaying all database connected -
Description
The Database Browser is not displaying all database connected.
-
Cause
The Database Browser component parses the tnsnames.ora file to create the DatabaseBrowser.tdp file in C:\Documents and Settings\<username>\Application Data\Quest Software\Toad for Oracle\9.7\User Files.
If the tnsnames.ora files use alia, more than one connect string name per entry, then the multiple entries get combined into one in the DatabaseBrowser.tdp file and isn't recognized. -
Resolution
DatabaseBrowser.tdb Modify the DtabaseBrowser.tdp file as follow shown in the example below.
4,TestDB1,TestDB1,,,,21,FALSE,,,FTP,
5,"ABCDE,MES_PPR",,"ABCDE,MES_PPR",,FALSE,10,FALSE <--- ABCDE not showing up
5,"VWXYZ,CITRIX_MES_PR",,"VWXYZ,CITRIX_MES_PR",,FALSE,10,FALSE
4,TestDB1,TestDB1,,,,21,FALSE,,,FTP,
5,ABCDE,,ABCDE,,FALSE,10,FALSE <--- ABCDE shows up now