Error in connecting when using the web config file

Question

0.00/5 (No votes)

See more:

Web config code as follows

HTML

<connectionstrings>

<add name="dbconnection" connectionstring="Mymachine\SQLSERVER2012; Integrated Security=true; Initial Catalog=Testing" providername="System.Data.SqlClient" />

</connectionstrings>

in .aspx code as follows

HTML

 protected void Page_Load(object sender, EventArgs e)
          {
            if (!IsPostBack)
            {

                this.BindGrid();
            }
        }



    private void BindGrid()
        {
string strConnString = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
            using (SqlConnection con = new SqlConnection(strConnString))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.CommandText ="select Tb_Employee";
                    cmd.Connection = con;
                    con.Open();
                    gvEmpdetails.DataSource = cmd.ExecuteReader();
                    gvEmpdetails.DataBind();
                    con.Close();
                }
            }
      }

When i run the application shows error as follows

>Keyword not supported: 'Mymachine\sqlserver2012; integrated security'

please what is the mistake in my above code

What I have tried:

Web config code as follows

HTML

<connectionstrings>

<add name="dbconnection" connectionstring="Mymachine\SQLSERVER2012; Integrated Security=true; Initial Catalog=Testing" providername="System.Data.SqlClient" />

</connectionstrings>


protected void Page_Load(object sender, EventArgs e)
          {
            if (!IsPostBack)
            {

                this.BindGrid();
            }
        }



    private void BindGrid()
        {
string strConnString = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
            using (SqlConnection con = new SqlConnection(strConnString))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.CommandText ="select Tb_Employee";
                    cmd.Connection = con;
                    con.Open();
                    gvEmpdetails.DataSource = cmd.ExecuteReader();
                    gvEmpdetails.DataBind();
                    con.Close();
                }
            }
      }


in .aspx code as follows

<pre lang="HTML">

When i run the application shows error as follows

>Keyword not supported: 'Mymachine\sqlserver2012; integrated security'

please what is the mistake in my above code

Posted 1-May-16 21:17pm

sudhakarthikeyan

Updated 2-May-16 0:00am

Santosh Kokatnur

v2

Add a Solution

Comments

madhav_jain 2-May-16 3:24am

check your connection string in Web.config file it should be in below format

<add name="ConnectionStringName" providername="System.Data.SqlClient" connectionstring="Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=False;User Id=userid;Password=password; ></add></div> <div id=" editdialogplaceholder"="">

Karthik_Mahalingam 5-May-16 7:09am

You never used to close any of the answers to your question..
Please then and there close the posts by marking it as answer or post your own answer which worked for you..
dont leave the questions as such. Its not good. being you are an active user you shouldnt do like this.

4 solutions

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)

Suvendu Shekhar Giri · Answer 1 · 2016-05-01T21:26:00

Try following-

XML

<connectionstrings>
<add name="dbconnection" connectionstring="server=Mymachine\SQLSERVER2012; Integrated Security=true; Initial Catalog=Testing" providername="System.Data.SqlClient" />
</connectionstrings>

or,

XML

<connectionstrings>
<add name="dbconnection" connectionstring="Data Source=Mymachine\SQLSERVER2012; Integrated Security=true; Initial Catalog=Testing" providername="System.Data.SqlClient" />
</connectionstrings>

You are missing "server=" or "Data Source=" in your connection string while providing the server name.

Hope, it helps :)

madhav_jain · Answer 2 · 2016-05-01T21:24:00

Solution 1

C#

check your connection string in Web.config file it should be in below format

<add name="ConnectionStringName">
providerName="System.Data.SqlClient"
connectionString="Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=False;User Id=userid;Password=password;>

Posted 1-May-16 21:24pm

madhav_jain

Updated 1-May-16 21:25pm

v2

koolprasad2003 · Answer 3 · 2016-05-02T00:00:00

Solution 4

Its connection string error
use below syntax

C#

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;
Password=myPassword;

and from your code it looks you have missed 'Server' and 'Database' keyword.
correct them. it will resolve your issue

Posted 2-May-16 0:00am

koolprasad2003

Santosh Kokatnur · Answer 4 · 2016-05-01T21:33:00

Just do like this...

If you don't want to give your machine name, just after the Data Source = .\SQLEXPRESS; add DOT behind slash! it will works fine...

HTML

<connectionstrings>>
    <add name="SAIConn" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Recuitment.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>

Error in connecting when using the web config file

4 solutions

Solution 2

Solution 1

Solution 4

Solution 3

Add your solution here

Preview 0