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)