Instance Failure Error in asp application

Question

0.00/5 (No votes)

See more:

I have instance failure error in code while connection string is right. plzz tell me hw can i remove this error..Thnxx.

<connectionstrings>
    <add name="ABC" connectionstring="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa">
      providerName="System.Data.SqlClient" />
    <add name="LastimageConnectionString" connectionstring="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa">
      providerName="System.Data.SqlClient" />
  </add></add></connectionstrings>

and code on .aspx.cs page is

C#

static string str = ConfigurationManager.ConnectionStrings["ABC"].ConnectionString;
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            filldropdown();
        }
    }
    //SqlConnection con = new SqlConnection(str);
    public void filldropdown()
    {
        //SqlConnection con = new SqlConnection(@"Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa");
        SqlConnection con = new SqlConnection(str);
****        con.Open();
        SqlCommand cmd = new SqlCommand("Select EmpID from Tbl_Emp", con);
        //if (con.State == ConnectionState.Closed)
        //{
        //con.Open();
        //}
        SqlDataReader dr = cmd.ExecuteReader();
        TextBox3.Items.Clear();
        if (dr.HasRows)
        {
            //TextBox3.DataSource = dr["EmpID"].ToString();
            //TextBox3.DataBind();

            while (dr.Read())
            {
                TextBox3.Items.Add(dr["EmpID"].ToString());
            }
        }
        con.Close();
    }

Its showing an error in stared line..plzz tell hw can i remove it.

Posted 10-Jan-14 1:38am

D.K.Pareek

Updated 10-Jan-14 1:39am

v2

Add a Solution

4 solutions

Solution 4

omit " \\ " from connection string in Data Source and use " \ " .

Posted 6-Aug-15 11:04am

Pravash Dash

Comments

[no name] 6-Aug-15 18:08pm

You mean replace something that does not exist in the connection string with something that is the same thing? Why? Why answer a question that has already been answered?

Solution 3

try this... <add name="myConSql" connectionstring="server=localhost;database=Lastimage;uid=sa;password=sasa" providername="System.Data.SqlClient"></add>

Posted 10-Jan-14 18:05pm

Member 9822231

Solution 2

use this

XML

<add name="ABC" connectionstring="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa" 
      providerName="System.Data.SqlClient" />
    <add name="LastimageConnectionString" connectionstring="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa" 
      providerName="System.Data.SqlClient" />

Posted 10-Jan-14 1:49am

Deviprasad Das

Updated 10-Jan-14 2:11am

v3

Comments

D.K.Pareek 10-Jan-14 7:55am

@deviprasad same as above. i think provider name cannt be out of >

Deviprasad Das 10-Jan-14 8:11am

Can you please paste the exception details?

D.K.Pareek 10-Jan-14 23:06pm

connectionstring attribute is not allowed and when i update connectionstring as C and S then It agian gives error in con.open();

InvalidOperationException was unhandeled by user code.
(Instance failure.)

[no name] 11-Jan-14 0:04am

try this... <add name="myConSql" connectionstring="server=localhost;database=Lastimage;uid=sa;password=sasa" providername="System.Data.SqlClient">

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Singh Shekhawat · Accepted Answer · 2014-01-10T01:43:00

Solution 1

Change your connection string section in web.config file like:

<connectionstrings>
    <add name="ABC" connectionstring="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa" providername="System.Data.SqlClient"></add> 
</connectionstrings>

Posted 10-Jan-14 1:43am

Sandeep Singh Shekhawat

Updated 10-Jan-14 17:18pm

v3

Comments

D.K.Pareek 10-Jan-14 7:49am

@sandeep Its showing Error in provider name and also in connectionstring as (element is not allowed)

Sandeep Singh Shekhawat 10-Jan-14 7:58am

Can you paste your error here.

D.K.Pareek 10-Jan-14 23:07pm

connectionstring attribute is not allowed and when i update connectionstring as C and S then It agian gives error in con.open();

InvalidOperationException was unhandeled by user code.
(Instance failure.)

Sandeep Singh Shekhawat 10-Jan-14 23:16pm

There are some common error in Web.Config file. Please use updated code which metion in above answer
<connectionstrings>
<add name="ABC" connectionstring="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa" providername="System.Data.SqlClient">

"S" in connection string would be in capital letter means "S" instead of small letter "s"

D.K.Pareek 10-Jan-14 23:29pm

I pasted ur above updated connectionstring bt gives error as Error

Unrecognized configuration section connectionstrings.

wen i change s in <connectionstring> as S which came in dropdownlist self then again gives error in connectionstring
wen i update as S then error in stared part..
<connectionstrings>
<add name="ABC" **connectionstring**="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa" providername="System.Data.SqlClient">

D.K.Pareek 10-Jan-14 23:37pm

@ sandeep sir plzz help me remove this error any how..i m in trouble..
can u do using teamviewer..if possible..

Sandeep Singh Shekhawat 10-Jan-14 23:39pm

Your connection string should be <configuration> section as a root.There <connectionstrings> tag has captial "S" of String in connectionStrings

D.K.Pareek 10-Jan-14 23:52pm

when i change s as 'S' then again gives error configuration error and connectionstring also bluelined.

Sandeep Singh Shekhawat 10-Jan-14 23:56pm

your connection string should be under configuration tag. can you paste your web.config file?

D.K.Pareek 11-Jan-14 0:26am

Thnxx for ur kind support sir..!! Problem Soveled..!!

Sandeep Singh Shekhawat 11-Jan-14 0:33am

Sounds good!! What was error? If my post was helpful then mark as accepted answer or upvoted it. Thanks

D.K.Pareek 11-Jan-14 0:57am

Error was in connection string typing. i replaced it many times so connectivity mistake with libraries.
Thnxx once again for ur Kind Support.

Member 13275563 9-Nov-17 16:53pm

Hello Sir,
My WinForms application have an error on client machine,when i login to application their are error Occured i.e., "Instance Failure".
then i tried many solutions for this error but still same error occured.plzz give me proper solution for this.Their connection string is as follows:<connectionstrings>
<add name="ABC.Properties.Settings.dbLnString"
connectionString="Data Source=NOTEBOOK\SQLEXPRESS;Initial Catalog=dbLn;User ID=sa;Password=sa1"
providerName="System.Data.SqlClient" />