View Single Post
  #1 (permalink)  
Old January 10th, 2014, 08:53 AM
hdossantos hdossantos is offline
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jan 2014
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Define LocalSqlServer dynamically at run time


As it's the first time I ask a question here I hope I'm doing it at the right place...

Here is my question : is there a way to define the LocalSqlServer string dynamically at run time?
I'm using .net 3.5, VS2008, c# and VB and it's for web projects.

Why do I want to do this?
Because I want the LocalSqlServer connection string data (host, login, password) to be centralised and not hard code on the web.config.

Ex: these data will be stored in the server system variables, managed by the IT, the websites will have to load and get these data to create the connectring at startup, there are many websites most of them will be using the same DB for LocalSqlServer.

Has I'm using the membership tables I must specify the LocalSqlServer string.

I hope my question and what I'm trying to do is enought clear... I'm yet far from being fluent in english !