Once I have sent an HTTP Post within a sql server procedure, I need to send a 2nd Post to the same target but with one or two changed parameters. I would prefer to do it inside the same procedure.
Does EXEC sp_OAMethod @http, 'SynchronousRequest', @resp OUT, @domain, @port, @ssl, @req also destroy the @http and @req objects? And if not, how can I delete one or more of the parameters, recreate them with different values, then resend the POST? Is there a 'DeleteParm' sort of method?
Or do I need to explicitly destroy and re-create everything from scratch again?
asked Jun 18 '12 at 08:34
The Chilkat HTTP object will keep the connection open if possible. If the HTTP response contains a "Connection: Close" header, then the server is telling the client that it should close the connection and that the next request should be on a new connection.
The Chilkat HTTP object automatically handles it. Whenever a method is called that requires an HTTP connection to a server, the object will automatically use the existing connection, or will automatically open a new connection if needed. Therefore, you should be able to simply call SynchronousRequest again on the same object instance.
If there is a problem, and you are using an older version, then best thing to do is to test with the very latest version.
If there is still a problem, you can force a new connection by calling http.CloseAllConnections().
answered Jun 18 '12 at 10:32