login about faq

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?

Thanks, Doug

asked Jun 18 '12 at 08:34

dshokes's gravatar image


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

chilkat's gravatar image

chilkat ♦♦

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: Jun 18 '12 at 08:34

Seen: 3,315 times

Last updated: Jun 18 '12 at 10:32

powered by OSQA