Hi everyone

I'm starting to layout the transition from VFP to a .NET/Winform application. One of the first concerns I for this development is that we write our application and sell it basicly as a verticial market product. When we sell it, we distrubute the software, and each facility is responsible for having a server for SQL. Right now, in our current application, I store that information servername and database name in a MEM file. If that file isn't there the first time the application is run, I pop up a dialog and get the information, make the connection and then save those values. It works great. The question is, where/how do I store that information for the .NET app. I'm sure there are multple ways do this, I'm hoping for the KISS way that will work for all users no matter what their workstation rights are.

The second is an understanding question. I've played around with the .NET now for the last year making little forms and learning some of the controls. But here is something that seems great but I don't know how it works when the application is distrubuted. That being, the connection controls to the database. In all the books and examples, you use the server explorer, and drag a table or database to the form, and it creates the connection information. When I distrubute this, or even go into the test environment, that server and connection information used will be totally different than what I develop on. I'm sure I'm missing how this can be more "generic" and useful in a distrubuted setting.

Thanks for any all all help.

Kirk