CreateObject("MSXML2.ServerXMLHTTP") not working (1 Viewer)

[smig]

I'm using CreateObject("MSXML2.ServerXMLHTTP") for long time to automatically download files from my server

recently I can't download getting an error with secured channel
I get the error on .Send

it does not netter if I send the file to get as HTTP or HTTPS

the files are public so no need for UserName or Password

http://noam.fuchsapps.com/App/Update/NoamLekochotVersion.txt

Public Function fnDownloadHTTP(strTarget As String, strSaveAs As String, Optional strUserName As String, Optional strPassword As String) As Boolean

' On Error GoTo errHere


Dim xmlHTTP As Object
Dim strRespText As String

fnDownloadHTTP = True

'Set xmlHTTP = CreateObject("Microsoft.XMLHTTP")
Set xmlHTTP = CreateObject("MSXML2.ServerXMLHTTP")

With xmlHTTP
    .Open "GET", strTarget, False, strUserName, strPassword
    .setRequestHeader "cache-control", "no-cache,must revalidate"
    .send
End With
 
If fnSaveDownloadFile(strSaveAs, xmlHTTP.responseBody) = False Then
    fnDownloadHTTP = False
End If
 
 
ExitHere:
    Set xmlHTTP = Nothing
    Exit Function
 
errHere:
    fnDownloadHTTP = False
    Resume ExitHere

End Function

 

[CJ_London]

not sure I can suggest anything - but what is the error description?

 

[smig]

not sure I can suggest anything - but what is the error description?

RunTime error -2147012739 Error support the secured channel (Translated from Hebrew)

 

[CJ_London]

take a look at this link - it suggests a slight different object

Excel VBA send to MSXML2.XMLHTTP does not work

I have the following code in excel VBA, and it worked well until yesterday. Now it fails when trying to check the URL.. but the URL does exist! It fails in line: oXHTTP.send (it goes to haveError)

stackoverflow.com

 

[cheekybuddha]

Do you need the actual file, or just the contents?

 

[Peter Reid]

I'm not sure if it helps but I've just pasted this function into a new Access (v1908 Office 365) file, added the fnDownloadHTTP function from https://www.vbforums.com/showthread.php?655907-Open-Save-pdf-Link and it downloads the file.

 

[smig]

Do you need the actual file, or just the contents?

Though at the end process I will need to download files, reading the content will be great
It's a simple one short line content with a version number

 

[cheekybuddha]

With the following simple function:

Function HTTP_Get(webServiceURL As String) As String

  Const XMLHTTP             As String = "MSXML2.ServerXMLHTTP", _
        METHOD_GET          As String = "GET", _
        HTTP_STATUS_SUCCESS As Integer = 200
    
  With CreateObject(XMLHTTP)
    .Open METHOD_GET, webServiceURL, False
    .setRequestHeader "cache-control", "no-cache,must revalidate"
    .Send
    If .Status = HTTP_STATUS_SUCCESS Then
      HTTP_Get = .ResponseText
'      Debug.Print .getAllResponseHeaders
'      Debug.Print .responseBody
    Else
      Debug.Print .Status & ": " & .StatusText
    End If
  End With
  
End Function

This is what I get in the Immediate Window (Ctrl+G):

?HTTP_Get("http://noam.fuchsapps.com/App/Update/NoamLekochotVersion.txt")
11.188

hth,

d

 

[The_Doc_Man]

When I look up error -2147012739 (which is, in hex 80072F7D) it tells me that there is some error in the encryption algorithm. By any chance did you have an upgrade of any sort - either on YOUR end or on the other end of this connection? It seems to be saying that the server certificate cannot be decoded. The suggestion is that you need to somehow update your Crypto API.

This is an older reference:

server giving msxml3.dll error '80072f7d' when trying to access secure url

For years I have used classic asp to connect to the secure site of a supplier using msxml3.dll - but since this morning, I am getting; msxml3.dll error '80072f7d' An error occurred in the secure

stackoverflow.com

Not quite as old but similar concept: Something is out of date

Classic ASP Error msxml3.dll error '80072f7d'

Dear Community, I have some old pages still using classic ASP to talk to the infusionsoft API and update contacts. For some reason it has stopped working even though the code has not changed. This is the error: msxml3.dll error ‘80072f7d’ An error occurred in the secure channel support...

community.infusionsoft.com

I've looked at several other links and they all more or less give variants of the same issue - that due to something being updated or something going out of date, you cannot establish the session because of a hashing method mismatch. It seems to be somewhat generic in that more than one kind of mismatch can trigger this.

 

[smig]

With the following simple function:

Function HTTP_Get(webServiceURL As String) As String

  Const XMLHTTP             As String = "MSXML2.ServerXMLHTTP", _
        METHOD_GET          As String = "GET", _
        HTTP_STATUS_SUCCESS As Integer = 200
   
  With CreateObject(XMLHTTP)
    .Open METHOD_GET, webServiceURL, False
    .setRequestHeader "cache-control", "no-cache,must revalidate"
    .Send
    If .Status = HTTP_STATUS_SUCCESS Then
      HTTP_Get = .ResponseText
'      Debug.Print .getAllResponseHeaders
'      Debug.Print .responseBody
    Else
      Debug.Print .Status & ": " & .StatusText
    End If
  End With
 
End Function

This is what I get in the Immediate Window (Ctrl+G):

?HTTP_Get("http://noam.fuchsapps.com/App/Update/NoamLekochotVersion.txt")
11.188

hth,

When I look up error -2147012739 (which is, in hex 80072F7D) it tells me that there is some error in the encryption algorithm. By any chance did you have an upgrade of any sort - either on YOUR end or on the other end of this connection? It seems to be saying that the server certificate cannot be decoded. The suggestion is that you need to somehow update your Crypto API.

This is an older reference:

server giving msxml3.dll error '80072f7d' when trying to access secure url

For years I have used classic asp to connect to the secure site of a supplier using msxml3.dll - but since this morning, I am getting; msxml3.dll error '80072f7d' An error occurred in the secure

stackoverflow.com

Not quite as old but similar concept: Something is out of date

Classic ASP Error msxml3.dll error '80072f7d'

Dear Community, I have some old pages still using classic ASP to talk to the infusionsoft API and update contacts. For some reason it has stopped working even though the code has not changed. This is the error: msxml3.dll error ‘80072f7d’ An error occurred in the secure channel support...

community.infusionsoft.com

I've looked at several other links and they all more or less give variants of the same issue - that due to something being updated or something going out of date, you cannot establish the session because of a hashing method mismatch. It seems to be somewhat generic in that more than one kind of mismatch can trigger this.

Thanks

I'll try to ask the server holder for assist
d

I get the same error, on .Send

 

[smig]

When I look up error -2147012739 (which is, in hex 80072F7D) it tells me that there is some error in the encryption algorithm. By any chance did you have an upgrade of any sort - either on YOUR end or on the other end of this connection? It seems to be saying that the server certificate cannot be decoded. The suggestion is that you need to somehow update your Crypto API.

This is an older reference:

server giving msxml3.dll error '80072f7d' when trying to access secure url

For years I have used classic asp to connect to the secure site of a supplier using msxml3.dll - but since this morning, I am getting; msxml3.dll error '80072f7d' An error occurred in the secure

stackoverflow.com

Not quite as old but similar concept: Something is out of date

Classic ASP Error msxml3.dll error '80072f7d'

Dear Community, I have some old pages still using classic ASP to talk to the infusionsoft API and update contacts. For some reason it has stopped working even though the code has not changed. This is the error: msxml3.dll error ‘80072f7d’ An error occurred in the secure channel support...

community.infusionsoft.com

I've looked at several other links and they all more or less give variants of the same issue - that due to something being updated or something going out of date, you cannot establish the session because of a hashing method mismatch. It seems to be somewhat generic in that more than one kind of mismatch can trigger this.

How do I update my Crypto API ?