Why am I having problems filling my dataset when I select fields of type
varchar(350) from interbase? I can fill the dataset when I select every
other field in the table but I receive and error message that says "object
reference not set to an instance of an object" when I return the varchar
field." The detailed error message is below.
Server Error in '/BIC_WEB_TEST' Application.
--------------------------------------------------------------------------------
Object reference not set to an instance of an object.
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.NullReferenceException: Object reference not set
to an instance of an object.
Source Error:
Line 42: baseconnection.ConnectionString = ConnectString
Line 43: baseconnection.Open()
Line 44: BICDataAdapter.Fill(BICDataSet, "recruit_report_data")
Line 45: Catch ex As System.Data.Odbc.OdbcException
Line 46: ErrorMessage = ex.Message
Source File: c:\inetpub\wwwroot\BIC_WEB_Test\RecruitReport.aspx .vb Line:
44
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an
object.]
System.Data.Odbc.OdbcDataReader.GetValue(Int32 i, TypeMap typemap)
System.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
System.Data.Odbc.OdbcDataReader.GetValues(Object[] values)
System.Data.Common.SchemaMapping.LoadDataRow(Boole an clearDataValues,
Boolean acceptChanges)
System.Data.Common.DbDataAdapter.FillLoadDataRow(S chemaMapping mapping)
System.Data.Common.DbDataAdapter.FillFromReader(Ob ject data, String
srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords,
DataColumn parentChapterColumn, Object parentChapterValue)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
BIC_WEB_TEST.RecruitReport.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\BIC_WEB_Test\RecruitReport.aspx .vb:44
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
--
Derek V. Taylor
UCI Brain Imaging Center