Response Text in Extended SP - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Response Text in Extended SP

Author

Topic

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-09-01 : 09:24:23

Hello,
Am using Extended SP (sp_oa***** ) groups, to pass values remotely to a website and using 'MSXML2.ServerXMLHTTP.3.0' Object.

Below are two lines of code I use to create the object and the second to access the property ResponseText.

Whe it fails i get the response value back. But when it succeeds, I get a null value back. Using @res

Any help on this, why its null ?

thanks
Ehi


EXEC @Return = sp_oacreate 'MSXML2.ServerXMLHTTP.3.0', @Object OUTPUT

EXEC @RETURN = sp_OAGetProperty @object,'ResponseText',@Res Out

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources