I can reach the URL without any problems using a browser or insomnia. Just not with the http connector.
What can be the cause of the -1 error code, or, where do I look for the problem?
Best answer by Vincent Doppenberg
View originalBest answer by Vincent Doppenberg
View originalEXEC sp_OACreate 'WinHttp.WinHttpRequest.5.1', @pointer OUTPUT
EXEC sp_OAMethod @pointer, 'open',NULL, 'GET', @URL,0
EXEC sp_OAMethod @pointer, 'send'
EXEC sp_OAMethod @pointer, 'Status', @status OUTPUT
EXEC sp_OAMethod @pointer, 'StatusText', @status_text OUTPUT
EXEC sp_OAMethod @pointer, 'responseText', @response_text OUTPUT
EXEC sp_OADestroy @pointer
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.