I'm using the OleDbConnection object to retrieve the contents of an
Excel Worksheet as a DataSet. This works fine when testing the
MyExcel.GetMonthly() method call.

When I call MyExcel.GetMonthly() from a Serviced Component, it bombs
when it tries to open the connection with "Object reference not set to
an instance of an object"

Code snippet:

    OleDbConnection cn = new OleDbConnection(CnString);
    cn.Open(); <-- Error occurs here

In an effort to isolate the problem I created a new class and called
MyExcel.GetMonthly() from it. Without ServicedComponent inheritence it
works fine. With ServicedComponent inheritence it worked until I added
the [ Transaction(TransactionOption.Required)] attribute, this threw
the error: "The ServicedComponent being invoked is not correctly
configured (use regsvcs to re-register)"

Any thoughts?