Where did you run SP from?

>
>I'm trying to use sp_OACreate from a sp to run a vb com and keep getting
>-2147024891, Access is denied., ODSOLE Extended Procedure. So I
>created a DTS and ran it from Job manager and it works just fine. It's
>run under the same user "SYSTEM". So obviously there's a difference
>between sp_OA* and CreateObject from a DTS. Probably some kind of
>security problem. Anyone have a clue???