"rogo" <goi***@saic.com> wrote in message
news:1137178024.175658.271390@g49g2000cwa.googlegroups.com...
> I'm having a problem getting the dataset to fill the datagrid.  Below
> is the error page.
>
> Thanks for any help.
>
> --------------------------------------------------------------------------------
>
> ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
> Incorrect syntax near '.'.
> 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.Odbc.OdbcException: ERROR [42000]
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
> near '.'.
>
> Source Error:
>
>
> Line 86:         Dim dsIData As New DataSet
> Line 87:         daIData.SelectCommand = New Odbc.OdbcCommand(GSQL,
> conn.CN)
> Line 88:         daIData.Fill(dsIData, "IData")
> Line 89:         With grdIData
> Line 90:             .DataSource = dsIData.Tables("IData")
>
>
> Source File: c:\inetpub\wwwroot\NAFCOMUser\IReport.aspx.vb    Line: 88
>
> Stack Trace:
>
>
> [OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL
> Server]Line 1: Incorrect syntax near '.'.]
>   System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle,
> SQL_HANDLE hType, RETCODE retcode)
>   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior
> behavior, String method) +1189
>   System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
> +47
>
> System.Data.Odbc.OdbcCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
> behavior) +5
>   System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior) +304
>   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior) +77
>   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
> srcTable) +36
>   NAFCOMUser.IReport.GetGridFiles() in
> c:\inetpub\wwwroot\NAFCOMUser\IReport.aspx.vb:88
>   NAFCOMUser.IReport.Page_Load(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\NAFCOMUser\IReport.aspx.vb:44
>   System.Web.UI.Control.OnLoad(EventArgs e) +67
>   System.Web.UI.Control.LoadRecursive() +35
>   System.Web.UI.Page.ProcessRequestMain() +731
>