I need to configure the executable so that at each installation the VB program can find the database server, change the connection string to point at the local server named in the config file.
I am sure you have all done this before but to me it is new stuff.

1. What is a good name and location for the configuration file with
the server name?

2. I make the
Public objConnection As New SqlClient.SqlConnection()
at the public class so the I can use it in several forms. True?

But then I need to execute the read config at the Load event so I can
add the server name to the connection string.
3. What is the syntax for modifying the objConnection to use the new string with the server name that I just read from the config file?

objConnection = strConnectionString < This doesn't work.

4. What is the best way to edit the strConnectionString to insert the server name found in the config file?

5. Is there an easy example available of program which does this stuff?

Thanks in advance,

Tom

1.
<ApplicationName>.cfg

If you put the cfg in the folder with the .exe, then you can find it with app.Path.
If you put it in the Windows directory, you can find it through Environ$("Windir").
You could always put it into C:\Program Files\Common Files\<ApplicationName>\<ApplicationName>.cfg . Then you’ll always know where it is.


2. That is quite useful. It is not always the best, so your situation would be determinative...


3.


4. Use 2 constants for the part of the connection string preceding the server name, and another for all after the server name. Then use

Thank you Brian.
That string concat works great. It runs fine on my pc in debug mode.

I have a new problem. After using click one deployment, the
program can't seem to write an update to the config file that it uses.
The program doesn't create any error messages but no writing to my file occurs.
Is this the way click one applications are supposed to act?
T :(