Connection String Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, friends,

We have a connection string in our .net app configuration file like the
follows:

"packet size=4096;data source=server349;persist security info=False;initial
catalog=universalDB;user=everyone;password=everyone;"

Since each server has its own database instance, each time we deploy app to
a new server, we have to modify connection string: changing data source name,
say, from server349 to server712

Can we have a connection string that we don't have to modify connection
string each time deploying to a new server? What is syntax?

Thank you for your help.
 
Thank you. I will change data source=server349 to data source=local

The reason why this is important to us is because sometimes people forgot to
change this parameter, and caused big problem since all data were updated in
the WRONG server.
 
Back
Top