Help! How to select initial catalog and server on app launch

Oct 6 2009 10:46 AM
I want to create a vb 2008 winform that lets the user select the db and server that the application should connect to instead of using the hardcoded connection string in my namespace. I looks as if once a winforms app launches, you are stuck. I use datagridviews created from datasets in visual studio 2008. I have googled for days, but nothing seems to work, although I know this is possible with visual studio 6 and its dataenvironment. This is driving me crazy, a user should be able to select the path and database easily. What if the server ip changes, or the databas goes from test to production, why do I have to compile a new exe everytime? arghh Someone, please help!