allow user to select database Server
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
Re: Re: Sakpal and dglienna
Quote:
Originally posted by RobDog888
My code will solve half the problem, finding all SQL servers on the
network. All thats left is to find all Oracle servers on the network.
Hi Robdog888,
Does it work on WinME ? Because When I tried the code, it did not list the SQL server instance running on my system.(SQL Server 7.0). I have MDAC 2.7 installed. does it work with this?
where do I get documentation for SQL DMO. because what I got was for C/C++
Re: I have got everything
Quote:
Originally posted by tvssarma
I have SQL-DMO installed and added reference etc. I checked the documentation. but the problem is when I tested it on my WInME machine with SQLserver 7.0, it did not return the name of the server.
From my post above (directly cut/paste put of the MS BOL)...
Quote:
The ListAvailableSQLServers method is supported only for servers and workstations running Microsoft Windows NT® 4.0 and Microsoft Windows 2000.
Re: Re: I have got everything
Quote:
Originally posted by szlamany
From my post above (directly cut/paste put of the MS BOL)...
You are absolutely correct. It was an oversight. I apologize