Server Error in '/' Application.

Incorrect syntax near the keyword 'ORDER'.

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: Incorrect syntax near the keyword 'ORDER'.

Source Error:


Line 174:
Line 175:        objCommand = New OleDbCommand(strSQL, objConnection)
Line 176:        objDataReader = objCommand.ExecuteReader()
Line 177:        topHTML = "<table cellpadding=0 cellspacing=5 border=0 width=810>"
Line 178:        topHTML = topHTML & "<tr>"

Source File: G:\PleskVhosts\rudolphsmusic.com\httpdocs\sheet-music.aspx    Line: 176

Stack Trace:


[OleDbException (0x80040e14): Incorrect syntax near the keyword 'ORDER'.]
   System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr) +1033278
   System.Data.OleDb.OleDbDataReader.NextResult() +421
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +235
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +116
   System.Data.OleDb.OleDbCommand.ExecuteReader() +6
   ASP.sheet_music_aspx.musicData(Object strName, Object strText, Object strImage) in G:\PleskVhosts\rudolphsmusic.com\httpdocs\sheet-music.aspx:176
   ASP.sheet_music_aspx.Page_Load(Object sender, EventArgs e) in G:\PleskVhosts\rudolphsmusic.com\httpdocs\sheet-music.aspx:98
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.9061; ASP.NET Version:2.0.50727.9062