Page 1 of 1

SSL support

Posted: Fri 28 Mar 2014 11:28
by civic9
Hi,

Does dbexpress ms sql driver support connections to ms sql server (2008 and above) using (SSL?) encryption?

Thanks and best regards.

Re: SSL support

Posted: Fri 28 Mar 2014 14:25
by AlexP
Hello,

You can use built-in SSL encryption. To do this, you need to set the Custom String parameter in the following way:
SQLConnection.Params.Add('Custom String=Encrypt=YES');

However, in such a case you need the custom certificate on the target PC. Please refer to MSDN for more detailed information.