I have created an application that allows you to copy any database to a brand new database. Right now it is setup to work with my local copy of MSDE and if I ever need it for another computer or server I just change the connection string inside my code and recompile.
I want to be able to take some of the hassle out of this and I can think of two ways of doing it. The easiest would be to just make a txt file that holds a connection string that is read at run time, but what I'd like to do is to be able to create some drop downs (much like the Connect to Database wizard in VS2k5) that will find all available servers and then list all their available databases for a user to select which to copy.
I have searched google and countless other sites but "data source" is so vague I get tons of unrelated results.
I'm basically looking for code to parse the available data/servers on a network/local PC into a drop down. After I figure that out I can easily create a login window for authentication and find the databases available on that server.
C# would be appreciated as that is what my current app is written in, but if you know how to do it in VB please post and I'll translate it myself.
Thanks in advance!!
Adam
I want to be able to take some of the hassle out of this and I can think of two ways of doing it. The easiest would be to just make a txt file that holds a connection string that is read at run time, but what I'd like to do is to be able to create some drop downs (much like the Connect to Database wizard in VS2k5) that will find all available servers and then list all their available databases for a user to select which to copy.
I have searched google and countless other sites but "data source" is so vague I get tons of unrelated results.
I'm basically looking for code to parse the available data/servers on a network/local PC into a drop down. After I figure that out I can easily create a login window for authentication and find the databases available on that server.
C# would be appreciated as that is what my current app is written in, but if you know how to do it in VB please post and I'll translate it myself.
Thanks in advance!!
Adam