I have written many small apps that use one MSSQL database.
Too late, I realized a problem.  The connection is hard coded in each
app.  And it's time to upgrade my server!
To keep this from haunting me in the future, is there a way to specify
a database connection in a central location?

Matthew

Matthew,

You can store it everywhere. Version 2.0 does it now with the designer
generated database parts in the app.config file.

\\\\
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add
name="WindowsApplication4.My.MySettings.NorthwindConnectionString"
            connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\test1\Northwind.mdb"
            providerName="System.Data.OleDb" />
    </connectionStrings>
etc.
///

I hope this helps,

Cor

Sync databound combobox to current bound record in form
Comparing 2 datatables...
how do you execute javascript after script is regsistered?
Dragging a file from Windows into My program
Whats this
Dynamic Menus with Events
ComboBox
vbScript eval() function equivalent in VB.Net - Dynamically evaluate code
Rounded form corners and a custom title bar
how to: remove unequal white spaces with trim method