Getting Error while connecting to DB using c#

Question

Is there anything wrong with this code? Please help me out.

protected void Button_Click(object sender, EventArgs e)
{
        string cs = "Data Source=SFSIND0402;Initial Catalog=TestDB;Integrated Security=SSPI;Provider=Microsoft.ACE.OLEDB.12.0";
        OleDbConnection conn = new OleDbConnection(cs);
        conn.Open();
        OleDbCommand insert = conn.CreateCommand();
        insert.CommandText="insert into Employee(ID, Name, Sex, Salary) values('003','Vedpathi','M',25000)";
        insert.Connection = conn;
        insert.ExecuteNonQuery();
        conn.Close();
}

I am getting the following error:

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done

(on line 22:conn.Open();)

Is Your provider correct? It seems to me, that You try to connect to Access. The provider should be SQLNCLI10. Isn't it? — ntohl
– ntohl, Commented Jul 16, 2015 at 11:12
Then why are you using an MS ACCESS OLEDB connection string? — CodeCaster
– CodeCaster, Commented Jul 16, 2015 at 11:12

Luaan · Accepted Answer · 2015-07-16 11:30:35Z

3

When connecting to an MS SQL database, use the MS SQL providers:

using (var connection = new SqlConnection(connectionString))
{
  connection.Open();

  var cmd = new SqlCommand(commandText, connection);
  cmd.ExecuteNonQuery();
}

answered Jul 16, 2015 at 11:30

Luaan

64.1k7 gold badges108 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:43:49Z

1

In addition to the solution Luaan mentioned, you should store your connection string in the config file of the app and also encrypt it.

Even if you use SSL encryption when communicating with the DB, an ill-indended person can extract the string variables, if he / she runs the application on his / her machine.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Jul 16, 2015 at 12:54

Dolhescu Stefan

212 bronze badges

Collectives™ on Stack Overflow

Getting Error while connecting to DB using c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related