Use ConnectionStringBuilder.. ~~~~~~~~~~~~~~~~~~~~~~~~ Harun Yiğit Legoz [HyundaiAssan - Senior Software Developer] [MCTS: .NET Framework 3.5, ASP.NET Applications]
[B : http://www.hylegoz.net] [B : http://hylegoz.spaces.live.com] [L : http://www.linkedin.com/in/hylegoz] [F : http://www.facebook.com/hylegoz] [T : http://twitter.com/hylegoz] Samuel Goldwyn<http://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html> - "I'm willing to admit that I may not always be right, but I am never wrong." On Mon, Sep 28, 2009 at 10:09 PM, digger_54 <[email protected]>wrote: > > Hi, > > Need some help in VS2005 vb.net. I need to change my connection string > to a different server depending on the location of a user, I have to > code to get the users location. > > connectionString="Data Source= location1;Persist Security > Info=True;Integrated Security=False;User > ID=Username;Password=PW;Unicode=True" > > How can I change the ="Data Source= location1 part of it if the person > belongs to location2? > > Thanks >
