The error “The message received was unexpected or badly formatted” usually is caused because the server and client might not possess a mutually supported cipher suite.
A common way to fix this issue is to use one of CData’s hidden connection properties, which is shared among all our drivers, no matter the edition. In the “Other” connection property, type the following value:
UseInternalSecurityAPI=True
UseInternalSecurityAPI, when set to TRUE will force the driver to use CData’s internal implementation of SSL, which supports more protocols and cipher routes than some versions of Windows. When the property is switched to TRUE, the driver will be completely independent from Windows’ Security API.
Please reach out to support@cdata.com if this does not resolve the problem for you.