September 17, 2010 at 12:23 am
Hey guys,
I'm not sure what this sp does. a previous developer created it and it has stopped working. I'm tryin to fix it but I'm having no luck. from what I understand it qeuries a url and gets the response xml back.
DECLARE @url varchar(300)
DECLARE @win int
DECLARE @hr int
DECLARE @text varchar(MAX)
SET @url = 'http://test.co.za/v1/runimport.asp'
EXEC @hr=sp_OACreate 'MSXML2.ServerXMLHTTP',@win OUT
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win
EXEC @hr=sp_OAMethod @win, 'Open',NULL,'GET',@url,'false'
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win
EXEC @hr=sp_OAMethod @win,'Send'
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win
EXEC @hr=sp_OAMethod @win,'waitForResponse', NULL, 6000
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win
/*EXEC @hr=sp_OAGetProperty @win,'ResponseText',@text OUTPUT
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win*/
IF object_id ( 'tempdb..#xml' ) is not null DROP TABLE #xml
CREATE TABLE #xml (data VARCHAR(MAX) NULL)
INSERT #xml ( data )
EXEC @hr=sp_OAGetProperty @win,'ResponseText'
SELECT * FROM #xml
DROP TABLE #xml
EXEC @hr=sp_OADestroy @win
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win
I changed the code a bit. I did some research and it said the ResponseText cannot be more than 8000 chars. was getting an error so the temp table seems to have fixed it.
however now I get an msxml3.dll errorr saying the operation timed out.
I would really appreciate some help as this fix is urgent and I'm badly stuck. thanks guys
September 17, 2015 at 1:18 pm
Did you ever get this working?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply