db connection

  • Thread starter Thread starter meh
  • Start date Start date
M

meh

I am wanting to give my users the same functionallity as the server explorer
connection utility. Does ne1 know where I might find some samples or
documentaion on putting together something like that....enumerate the SQL
servers and MSDE etc.


tia
meh
 
you can use SQLDMO component to develop SQL Server Explorer or that kind of
application.

hope this helps.
 
Thx this looks like it will do the trick but I have questions......

1. Am I right in assuming that this is not "pure" dotNet??

2. Am I right in assuming that ADO.Net has no facilities to look at (or
for)servers....ADO.Net takes over after you have connected to a database.

3. Am I on the right track here????


tia
meh
 
yes, ADO.NET doesnt provide any facilities to create your own SQL
Enterprise Manager or a kind of tat application, you need to use SQLDMO
which comes when you install SQL Server with SQL itself. and its plain COM
object not a managed code. so its not a pure .NET

hope this clears it.
 
Back
Top