InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 02:35:39 GMT20http://www.teradata.com/teradataforum/Topic5226-11-1.aspxWhat is your query?Tue, 14 Nov 2006 17:49:53 GMTBlack Birdhttp://www.teradata.com/teradataforum/Topic5226-11-1.aspxTeradata OLEDB works fine from Visual Studio 2003/C# but does not work in ASP.NET 2.0 with .NET 2.0.<br><br>I am trying to issue a simple select stmt and get the following error:<br><br>[NCR][Teradata RDBMS] Syntax error, expected something like a name or '(' between the 'FROM' keyword and the end of the request. <br><br>[OleDbException (0x80040e14): [NCR][Teradata RDBMS] Syntax error, expected something like a name or '(' between the 'FROM' keyword and the end of the request. ]<br> System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult) +114<br> System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +163<br> System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +56<br> System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +105<br> System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +91<br> System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +4<br> System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139<br> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139<br> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83<br> System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1658<br> System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +13<br> System.Web.UI.WebControls.DataBoundControl.PerformSelect() +140<br> System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +68<br> System.Web.UI.WebControls.GridView.DataBind() +4<br> System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +61<br> System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +67<br> System.Web.UI.Control.EnsureChildControls() +97<br> System.Web.UI.Control.PreRenderRecursiveInternal() +50<br> System.Web.UI.Control.PreRenderRecursiveInternal() +171<br> System.Web.UI.Control.PreRenderRecursiveInternal() +171<br> System.Web.UI.Control.PreRenderRecursiveInternal() +171<br> System.Web.UI.Control.PreRenderRecursiveInternal() +171<br> System.Web.UI.Control.PreRenderRecursiveInternal() +171<br> System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731<br> <br><br> <br><br><br>--------------------------------------------------------------------------------<br><br>Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42<br>Wed, 20 Sep 2006 11:09:08 GMTrstaubit