My application can use both Oracle and SQL Server as back end.
On the first run, it prompts the user to select a DB Server. Based on the selected DB Server, it will load the appropriate Data access components.
For example, I want to check if there is an Oracle (or SQL Server) Instance running -If it is running, I can use the instance to create my database etc. even if the instance is not running I should be able to retrieve the details of installed DBases on the Machine-that's what utilities like TOAD or TORA do.
My problem is, how do I enumerate available DB servers on a system. They can be either Oracle(any version) or SQL server, so that I can present a drop down list box of available DB servers for the user to select from.
I don't want to just enumerate the DSNs available on the machine. The problem is complicated since these databases can be installed on remote computers in a networked environment.
Any help is highly appreciated
Reply With Quote