[RESOLVED] [2005]Update Connection String

[vuyiswamb]

Good Afternoon

My Application is Structured in a Way that before you login you must First Select a Database. Now i have one page that i want to change the Connection String Database name.

I have this function that get called on page load

    /*This Function will change the Connection string in the web.congif file based on the Database that exists on the 
     * session Variable. If there is nulll then set odirect3 as a current Database name.
     */
    public void UpdateConfig()
    {
        CommonFunctions obj = new CommonFunctions();

        

        String strKey = "NEWDT";
 
        String StrDatabase;

        if (Session["ActiveDatabase"] != null)
        {
            StrDatabase = Convert.ToString(Session["ActiveDatabase"]);
        }
        else
        {
            StrDatabase = "oDirectv3";
        }
 
        String strValue = @"User id=sa;Password=wow;Server=www; Database="+StrDatabase;

        Configuration objConfig = WebConfigurationManager.OpenWebConfiguration("~");

        AppSettingsSection objAppsettings = (AppSettingsSection)objConfig.GetSection("appSettings");

        if (objAppsettings != null)
        {
            objAppsettings.Settings[strKey].Value = strValue;

            objConfig.Save();
        }
    }

On the Development site it works well. But while still debugging the code, checking if its doing what i want, There is a point where it has to save the changes

    objConfig.Save();

The Part will execute and message box will appear asking me if i really want to save the changes made, i will save yes and everything will be fine. But if i don debug it , it gives an Error that says

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

How can i do this and Suppress this dialogs


Thank you

[Fishcake]

Seeing as it works on your development machine but not when deployed it sounds like it could be a couple of things.

1. It could be permissions based so make sure aspnet_user has write access to the folder with your config file and then try it again.
2. Is the server address/IP address visible from your deployment machine?

[mendhak]

Your connection string should look like this

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

[vuyiswamb]

I would like to take a Chance to thank you for your help. The code is working. i created the Following

        /*This Function will change the Connection string in the web.congif file based on the Database that exists on the 
        * session Variable. If there is nulll then set odirect3 as a current Database name.
        */

        private string GetConnectionString(string DB) // where DB is your database name from the session
        {

            string connString = ConfigurationManager.ConnectionStrings["NEWDT"].ConnectionString;

            if (DB != null)
            {
                return connString.Replace("NEWDT", DB);
            }
            else
            {
                return connString.Replace("NEWDT", "oDirectv3");
            }

        }

and in my Functions i called the above Function like this

        /* This Function will Help you Disable the Grid. What is Passed here is the 
   *name of the Subject and its going to Return a Pattern of Cycles to disable
   */

        public String Disable_Grid_Contents(String Pattern, String DB)
        {
            strcon = GetConnectionString(DB);

            con = new SqlConnection(strcon);


            cmdselect = new SqlCommand();

            cmdselect.CommandText = "dbo.Get_Pattern";

            cmdselect.CommandTimeout = 0;

            cmdselect.CommandType = CommandType.StoredProcedure;

            cmdselect.Connection = con;

            cmdselect.Parameters.Add("@S", SqlDbType.NVarChar, 63).Value = Pattern;

            cmdselect.Parameters.Add("@NS", SqlDbType.NVarChar, 128);

            cmdselect.Parameters["@NS"].Direction = ParameterDirection.Output;

            String PatternString;

            try
            {
                con.Open();

                cmdselect.ExecuteNonQuery();

                PatternString = (String)cmdselect.Parameters["@NS"].Value;
            }
            catch (SqlException)
            {
                throw;
            }
            finally
            {
                if (con != null)
                {
                    con.Close();
                }

            }
            return PatternString;
        }

Now i dont need to change the Connection string every time a page run, i will just replace the value of a DB.

Thank you Guys

[mendhak]

Alright, you may want to consider giving your parameters better names though... @S and @NS may confuse whoever looks at this in the future

Another way to do what you did is to store {0} in the connection string instead of the database and to use String.Format() to replace the {0} with the passed database name.

[vuyiswamb]

Good Point mendhak

I have already changed the named to meaningfull ones and i value you your suggestion.

Thank you Man