	AllExperts > Experts
	Search

About Rohit Prakash
Expertise
I can answer questions on VB.NET 2003. Areas include: Designing/Developing/Deploying desktop/client-server applications. I can also help in database connectivity using ADO.NET to connect to popular databases like Oracle,Access,SQL Server,MySQL,PostgreSQL etc.

Experience
I have 3 years experience using Visual Basic.NET in corporate environments. I have been providing consulting to private organizations and large departments and also developed solutions for custom needs.

Education/Credentials
Master of Computer Applications.

You are here: Experts > Computing/Technology > Basic > VB.NET > server names

Topic: VB.NET

Expert: Rohit Prakash
Date: 2/12/2007
Subject: server names

Question
Hello rohit

Can i get the list of all the server names,all the database names and all the existing users from sql server 2000 in my vb.net program?
The problem is to do this we need to connect to the database
and to connect to the database we need the server name and the database name etc.
Is there a way to do this?
I dont want the user to type in the server name and the database name.

Thanks in advance

Answer
Sourav,

You need to check the SQL DMO properties for the same. However following links may be of help to you:

http://www.sqldev.net/sqldmo/SQL-DMO.NETEventsVB.htm

http://www.a1vbcode.com/app-3869.asp

http://www.informit.com/articles/article.asp?p=27199&rl=1

......
Rohit.

Add to this Answer Ask a Question

About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.