So for some reason I keep getting TCP 0 and TCP 35
Microsoft.Data.SqlClient.SqlException: ‘A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 35 – An internal exception was caught)’
When running this query:
string addclnt = ("INSERT INTO " + Table +
"([c_first_name], [c_last_name], [c_business], [c_phone],[c_e_mail],[c_address],[c_city],[c_zip],[c_cnotes]," +
"[b_first_name],[b_last_name],[b_business],[b_phone],[b_address],[b_city],[b_zip]," +
"[l_business],[l_phone],[l_address],[l_city],[l_zip],[job_type],[job_date],[job_completed],[job_workdetails])" +
"VALUES" +
"(@c_first_name,@c_last_name,@c_business,@c_phone,@c_e_mail,@c_address,@c_city,@c_zip,@c_cnotes," +
"@b_first_name,@b_last_name,@b_business,@b_phone,@b_address,@b_city,@b_zip," +
"@l_business,@l_phone,@l_address,@l_city,@l_zip,@job_type,@job_date,0,@job_workdetails)");
SqlCommand cmd = new SqlCommand(addclnt, conn);
cmd.Parameters.Add("@c_first_name", SqlDbType.VarChar, 50).Value = c_first_name.Text.Trim();
cmd.Parameters.Add("@c_last_name", SqlDbType.VarChar, 50).Value = c_last_name.Text.Trim();
cmd.Parameters.Add("@c_business", SqlDbType.VarChar, 50).Value = c_business.Text.Trim();
cmd.Parameters.Add("@c_phone", SqlDbType.VarChar, 50).Value = c_phone.Text.Trim();
cmd.Parameters.Add("@c_e_mail", SqlDbType.VarChar, 50).Value = c_email.Text.Trim();
cmd.Parameters.Add("@c_address", SqlDbType.VarChar, 50).Value = c_address.Text.Trim();
cmd.Parameters.Add("@c_city", SqlDbType.VarChar, 50).Value = c_city.Text.Trim();
cmd.Parameters.Add("@c_zip", SqlDbType.VarChar, 50).Value = c_zip.Text.Trim();
cmd.Parameters.Add("@c_cnotes", SqlDbType.NVarChar, 8000).Value = "".Trim();
cmd.Parameters.Add("@b_first_name", SqlDbType.VarChar, 50).Value = b_first_name.Text.Trim();
cmd.Parameters.Add("@b_last_name", SqlDbType.VarChar, 50).Value = b_last_name.Text.Trim();
cmd.Parameters.Add("@b_business", SqlDbType.VarChar, 50).Value = b_business.Text.Trim();
cmd.Parameters.Add("@b_phone", SqlDbType.VarChar, 50).Value = b_phone.Text.Trim();
cmd.Parameters.Add("@b_address", SqlDbType.VarChar, 50).Value = b_address.Text.Trim();
cmd.Parameters.Add("@b_city", SqlDbType.VarChar, 50).Value = b_city.Text.Trim();
cmd.Parameters.Add("@b_zip", SqlDbType.VarChar, 50).Value = b_zip.Text.Trim();
cmd.Parameters.Add("@l_business", SqlDbType.VarChar, 50).Value = l_business.Text.Trim();
cmd.Parameters.Add("@l_phone", SqlDbType.VarChar, 50).Value = l_phone.Text.Trim();
cmd.Parameters.Add("@l_address", SqlDbType.VarChar, 50).Value = l_address.Text.Trim();
cmd.Parameters.Add("@l_city", SqlDbType.VarChar, 50).Value = l_city.Text.Trim();
cmd.Parameters.Add("@l_zip", SqlDbType.VarChar, 50).Value = l_zip.Text.Trim();
cmd.Parameters.Add("@job_type", SqlDbType.VarChar, 50).Value = job_type.Text.Trim();
cmd.Parameters.Add("@job_date", SqlDbType.VarChar, 50).Value = job_date.GetDate();
cmd.Parameters.Add("@job_workdetails", SqlDbType.NVarChar, 8000).Value = job_notes1.Text.Trim();
conn.Open();
cmd.ExecuteNonQuery();
But when i run this query i dont get TCP errors and it executes:
string addclnt = ("INSERT INTO " + Table +
"([c_first_name], [c_last_name], [c_business], [c_phone],[c_e_mail],[c_address],[c_city],[c_zip],[c_cnotes]," +
"[b_first_name],[b_last_name],[b_business],[b_phone],[b_address],[b_city],[b_zip]," +
"[l_business],[l_phone],[l_address],[l_city],[l_zip],[job_type],[job_date],[job_workdetails],[cstatus],[cancled],[job_completed])" +
"VALUES" +
"('sample','sample','sample','555-555-5555','sample','sample','sample','sample','sample'," +
"'sample','sample','sample','555-555-5555','sample','sample','sample'," +
"'sample','555-555-5555','sample','sample','sample','sample',FORMAT(GETDATE(), 'MM/dd/yyyy'),'sample',0,0,0)");
SqlCommand command = new SqlCommand(adddb, conn);
SqlCommand command2 = new SqlCommand(addclnt, conn);
try
{
conn.Open();
command.ExecuteNonQuery();
command2.ExecuteNonQuery();
Also This will Execute as well:
string jobs = ("DELETE FROM " + Table + " WHERE [Id] = @num3");
using (SqlCommand cmd = new SqlCommand(jobs, conn))
{
cmd.Parameters.AddWithValue("@num3", deljobid.Text);
conn.Open();
cmd.ExecuteNonQuery();
So im not sure what is making the TCP fail
I have tried making the fail query with addwithvaleues and still get fail.
I have also tried to Limit the data being processed to a lower amount.