"david clark" wrote:

> Hello,
>
> we have developed a COM+ data access component. It works fine in test
> (server application installed on client with dev studio) but in production
> (application proxy installed) several functions throw
> System.NullReferenceException.
>
> our function GetData opens an SqlConnection, creates a new SqlDataAdapter
> and calls Fill on that adapter passing it a DataSet defined locally in the
> function.
> We have verified that the connection is open, the SQL is good, the adapter
> seems okay. it is very weird, and I am at a bit of a loss as to what it could
> be.
>
> The same SQL is called each second and it works in the order of 4 out of 5
> times.
>
> Any help would be _greatly_ appreciated.
>
> _
> David K Clark
>
> this is the (partial) stack trace:
>
> System.NullReferenceException: Object reference not set to an instance of an
> object.
> at System.Data.SqlClient.SqlCommand.ValidateCommand(String method,
> Boolean executing)
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
> at
> System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
> at Umen.DataPlusRemote.DBConnect.GetData(String xSQL)