Click to See Complete Forum and Search --> : How to recognise a database server in the network ?


Genie
April 9th, 1999, 04:33 PM
Hi,

I want to create an activex control for data access. I have a property in the server called myserver. when my control is instanciated in any client, the myserver property ( in the property browser of the client ) should be dynamically populated with all the up and running database servers on the network - be it oracle, db2 or ms sql server!.

Can i achieve this, if yes, how ?

Take care
Genie.

Ciao till i find more questions to make life more complicated......

Lothar Haensler
April 13th, 1999, 09:19 AM
I don't know about the other database systems you mentioned, but with the "Microsoft SQLOLE object library" that comes with SQL server 6.5 you can get a list of SQLServers by calling the ListAnnouncedNetworkSQLServers global method.