How to form connection string to enable “force pro

2019-09-09 13:50发布

问题:

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.