在sql server中使用ole自动化程序发送短信 [英] send sms using ole automation procedures in sql server

问题描述

ALTER PROCEDURE rsp_CallWebService @sUrl NVARCHAR(MAX)
AS 
BEGIN  
  DECLARE @iReq INT,
    @hr INT 
  DECLARE @errorSource VARCHAR(8000)
  DECLARE @errorDescription VARCHAR(8000) 
  DECLARE @sResponse NVARCHAR(MAX)
  EXEC @hr = sp_OACreate 'Microsoft.XMLHTTP',@iReq OUT

  EXEC @hr = sp_OAMethod @iReq,'Open',NULL,'GET',@sUrl,'false'
  if @hr<>0 
		print ' Failed in sp_OAMethod open'
  EXEC @hr = sp_OAMethod @iReq,'send'
  if @hr<>0 
		print ' Failed in sp_OAMethod send'
  BEGIN
	set @hr=0
    EXEC @hr = sp_OAGetProperty @iReq,'responseText',@sResponse OUT
	if @hr<>0 
		print ' Failed in sp_OAGetProperty'
  END

  
  EXEC sp_OADestroy @iReq
  EXEC sp_OADestroy @hr
END 
GO

我想使用此程序发送短信（在@sUrl中）。但我收到一个错误sp_OAMethod发送失败和sp_OAGetProperty失败。

I want to send a sms(in @sUrl ) using this procedures. but i got a error Failed in sp_OAMethod send and Failed in sp_OAGetProperty.

推荐答案

注册后msxml3.dll工作正常......

After register msxml3.dll its working fine...

这篇关于在sql server中使用ole自动化程序发送短信的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！