dev775
asked on
SQL Server Connection String Utility
Need help to create a utility program that can simplify the configuration of the connection string for a client workstation to connect to a named instance of an SQL Server. This utility must provide an extremely basic interface so as to be intuitive to even the most illiterate computer user - there would be a drop-down box listing all servers on the network. Once the user selects the server with the "MYAPP" instance, the utility would read the selected data and add it to the app.config setting. The DB password will be hard-coded into the app. Need help with the design and coding of this tool. Not sure how to "look" for available servers.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
add refernce -> Com - > SQL DMO Object
Microsoft SQLDMO Object Library
ASKER
Ok, thanks. I will give this a try. May need a little more help after getting into it.