Server Error in '/' Application.

Syntax error (missing operator) in query expression 'DistinctSurname Like 'O'Dell%''.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression 'DistinctSurname Like 'O'Dell%''.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[OleDbException (0x80040e14): Syntax error (missing operator) in query expression 'DistinctSurname Like 'O'Dell%''.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1217017
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +256
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +216
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +60
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +164
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +115
   System.Data.OleDb.OleDbCommand.ExecuteReader() +12
   Common.clsDataFunctions.m_GetPersonReferences(Int32 m_StartYear, Int32 m_EndYear, String m_Firstname, String m_Surname, String m_OccupationCode, String m_RecordType) in F:\Documents\Visual Studio 2010\Projects\pirtonhistory people search\Common\clsDataFunctions.cs:188
   Common.clsDataFunctions.GetPersonReferences(Int32 StartYear, Int32 EndYear, String Firstname, String Surname, String OccupationCode, String RecordType) in F:\Documents\Visual Studio 2010\Projects\pirtonhistory people search\Common\clsDataFunctions.cs:276

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +168
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +105
   System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +682
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1661
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +22
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +151
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +76
   System.Web.UI.WebControls.GridView.DataBind() +10
   pirtonhistory.org.uk.Results.Page_Load(Object sender, EventArgs e) in C:\Users\Tara\documents\visual studio 2010\Projects\pirtonhistory people search\pirtonhistory people search\Results.aspx.cs:72
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0