MS SQL안에서 WEB으러 데이터가 보낼일이 있어서 검색결과 관련 내용을 찾아서 적용 했더니 잘됨. link : http://jarrettmeyer.com/2017/07/08/sql-server-sending-http-requests ALTER Procedure [dbo].[SP_ADD_xxxxxxx] as BEGIN DECLARE @authHeader NVARCHAR(64); DECLARE @contentType NVARCHAR(64); DECLARE @postData NVARCHAR(2000); DECLARE @responseText NVARCHAR(2000); DECLARE @responseXML NVARCHAR(2000); DECLARE @ret INT; DECLARE @status NVARCHAR(32); DECLARE @statusText NVARCHAR(32); DECLARE @token INT; DECLARE @url NVARCHAR(256); --SET @authHeader = 'BASIC 0123456789ABCDEF0123456789ABCDEF'; SET @contentType = 'application/x-www-form-urlencoded'; SET @postData = 'ID=Hello&age=33' SET @url = 'http://xxx.xxxxxx.net/index2.php' -- Open the connection. EXEC @ret = sp_OACreate 'MSXML2.ServerXMLHTTP', @token OUT; IF @ret <> 0 RAISERROR('Unable to open HTTP connection.', 10, 1); -- Send the request. EXEC @ret = sp_OAMethod @token, 'open', NULL...
댓글
댓글 쓰기