Hi Sergey,
I got it to work finally, the problem was I had a VB COM EXE not a DLL so I recompiled it as a DLL and changed the threading model to Both and used a DLL surrogate DLLHost for out-of-process and now it works fine. Funny the EXE worked on my test server but not on my production server. Well guess I never know why.
>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???
Magnus NordinVFP MCP
"We have tested the GUI on 5-year olds. Why? Beacuse they aren't braindead!"
Michael Spindler, Apple