As far as I know you cannot get around this using a single property. You might be able to break a return value down and return it in several properties, or some kind of index passed in..

You might be able to try a SQLCLR wrapper around the COM object.

Either way I suggest moving away from OLE Automation using the sp_OA methods.

CEWII