Connection String Machine Independent.

[Manny]

Hi there,

I've been researching on the diferent newsgroups to find out how to do this,
but no luck so far.

I'm developing a client/server windows application with VB.NET, MSDE is my
backend database.

This is sample connection string to connect to my server:
data source=MACHINE_NAME\MSDE; initial catalog=DatabaseName; user
ID=sa;password=sa

Now, when I distribute this application, the Server will have to be
installed in one machine in the LAN, now the connection string it's
hardcoded right now to look for a specific machine name and the instance
name.

So, how can I build, if it's possible, the connection string machine
independent?



Thanks very much,



Manny

 

[Dave Fancher]

One possible solution: configuration files
http://msdn.microsoft.com/library/d...e/html/cpconapplicationconfigurationfiles.asp

The link describes the structure of configuration files and how to use them
from both Windows Forms or ASP.NET applications. The server name in the
config file would have to be updated when deployed but there are ways to
automate that process.