I am using Microsoft OLE DB Provider for SQL Server in my MFC application to use database.I want to my connection to use ssl encryption for connection. My code looks like:
String SQL_connData = "provider=SQLOLEDB;";
SQL_connData += "Encrypt=true;";
SQL_connData += "TrustServerCertificate=true;"
It seems it doesn't use the SSL certificate installed on server machine. Can somebody let me know how to write the connection string in such case?
Many Thanks.