Database Connection Setting?

[mythinky]

Helo, I am building a database driven website using VB.Net. Problem occurs when I move the website to another computer for testing deploying. I have noticed the problems is come out from the database connection setting. How could I build it thus the user can set the database connection setting according to what they have? Learning .NET

[sukesh g]

Hi, For this you need to provide a User Interface Screen for taking the DataBase Server Connection details like UserId,Password,Server Name. Store this values in a TextFile which is used for connecting to the Database server which User wants. Hope this solution will be solve your problem...... Sukesh. Sukesh.g

[VenkatFor NET]

The best for storing Connection String is Web.Config, as this file get loaded dynamically and takes affect when something is changed in the file. Unfortunately, we can not have a user interface within a Web Application to modify this file. As an alternative, I have created a simple one form VB.NET application which dynamically loads all the databases avaiable on ther server so that the application builds connection string and modifies the web.config file. As this file is like a simple xml file to a VB.NET project application. So, on the deployed machine, if somebody wants to change the connection string, they can just go to this tool application and change the web.config. hope this helps. Bhaskara