On Premise SQL Server connector doesn't appear to be passing a method to the SEC

[garyev...@gmail.com]

Hi,

I've configured a connector to use RDCP to retrieve data from a local SQL Server database via SEC. I have successfully tested this locally through googles 'Dev HTTP Client', however, when I launch the RMP connector the SEC reports that no http method is specified and that it will default to 'GET', a 400 (Bad request
) is then returned.

I'm guessing the Get is causing this issue (please correct me if I am wrong). Am I supposed to be able to configure the RMP connector to send a 'POST' http method when using RDCP?

Any help would be appreciated.
Thanks
Gary

[thoshino]

Hi Gary,

I am assuming you recently installed the SEC and DB Adapter, which would be the enhanced version compared to the previous ones.

In that case, RDCP protocol will not work.

DB Adapter APIs were changed, it doesn't use the HTTP headers for parameters (= RDCP protocol) anymore.

We are working to update the documentation on it, sorry about that.

Instead you would pass the parameters as POST request, like the example here:

http://docs.runmyprocess.com/Integration_Guide/SEC/Adapters/JDBC#running-and-testing-the-adapter

Please configure the Provider and Connector just as you did for DevHttpClient (send a POST request to the DB Adapter).

It seems that you were already aware of all of the above, and RDCP protocol was just misleading.

I hope this helps,

Taka

[garyev...@gmail.com]

Cool, thanks very much for your help.

Gary