Set the TrustedFile property in the connection string to the file name
of the trusted roots file, before you enable SSL. The file name should contain the
path to the file as well.
- Set the Encryption property in the connection string to
ssl.
- Launch the ODBC DataSource Administrator.
- Select the datasource name (DSN) you would like to use and choose
Configure.
- Click the Connection tab.
- Select UseSSL in the Secure Socket Layer Group.
- Provide the complete path to the trusted roots file in the
TrustedFile field.