sp_OACreate error on SQL Server 2005

Posted by Johnny Lamho on Stack Overflow See other posts from Stack Overflow or by Johnny Lamho
Published on 2009-08-31T07:36:00Z Indexed on 2010/04/08 0:03 UTC
Read the original article Hit count: 279

Filed under:

hi there,

I have a stored procedure and trying to run "sp_OACreate" but fall over with the following message:

Msg 50000, Level 16, State 1, Procedure HTTP_REQUEST, Line 26 sp_OACreate on MSXML2.XMLHttp.4.0 failed

That occurs because I am setting a variable to get the return value of sp_OACreate and raise the above error if the return value is not 0. Now, the return value I get is "-6" but i don't know why it is happening? Any help on this would be good to help make this work.

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server