String or binary data would be truncated. The statement has been terminated

Error message got from SQL server,

soultion here:





Error message extacly return as follow:

System.Data.OleDb.OleDbException: The statement has been terminated.
String or binary data would be truncated.
at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr)
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteScalar()
at userPostLinkFromWeb2.insertNewLink(Object sender, EventArgs e) in d:\BSMS\UserPostLinkFromWeb2.aspx.cs:line 122@



Probelm related:

probably u are trying to insert values in a column in a table greater than the max length of the column specified.

ie. u have specified max length for a column as 20 the string u are trying to insert is greater than 20



Action taken:

Resize the table columns from 50 to 255 and problems solved.

powered by performancing firefox