0

Hmmm ok

Im stiil trying to figure out how to set that up properly ... Teratrax Performance Agent > Server Configuration > SQL Server Instance name.

0

It might be MSSQLSERVER or SQLEXPRESS

Hi, that program requires Oracle client and networking components! Why is that if im only using SQL Server

0

please select coding please currect

        private void button3_Click(object sender, EventArgs e)
    {
        String constr = "server=SYSTEM-1\\SQLEXPRESS;Initial Catalog=anbu;user id=sa;password=missoft";
        SqlConnection con = new SqlConnection(constr);
        con.Open();

        SqlCommand com = new SqlCommand("procemp_sel", con);
        //SqlDataAdapter sqlda = new SqlDataAdapter(com);
        //DataSet ds = new DataSet();

       //com.Parameters.Add("@Empcode", SqlDbType.Int).Value = textBox1.Text;
        com.Parameters.Add("@FName", SqlDbType.NVarChar).Value = textBox2.Text;
        com.Parameters.Add("@LName", SqlDbType.NVarChar).Value = textBox3.Text;
        com.CommandType = CommandType.StoredProcedure;

        //com.Parameters[0].Value = textBox1.Text ;
        com.Parameters[0].Value = textBox2.Text ;
        com.Parameters[1].Value = textBox3.Text ;

        SqlDataAdapter sqlda = new SqlDataAdapter(com);
        DataSet ds = new DataSet();
        sqlda.Fill(ds);
        con.Close();

        {
            sqlda.Fill(ds);
            con.Close();
        }


    }
0

if the number of parameters are same then try to check their types. parameter types must be the same as in the table

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.