MSMXL3.dll The operation timed out. XMLHTTP

  • niteshrajgopal

    SSCommitted

    Points: 1877

    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

  • MyDoggieJessie

    SSC-Forever

    Points: 44276

    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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply