Feedback

Feedback

Did this article resolve your question/issue?

   

Article

How to use encryption with the Connect for ODBC 7.1 SQL Server Wire Protocol driver

Printable View

Information

 
TitleHow to use encryption with the Connect for ODBC 7.1 SQL Server Wire Protocol driver
URL NameHow-to-use-encryption-with-the-Connect-for-ODBC-7-1-SQL-Server-Wire-Protocol-driver
Article Number000184249
EnvironmentProduct: Connect for ODBC DB2 Wire Protocol driver
Version: 7.1
OS: All supported platforms
Database: All supported SQL Server databases
Application: All application
Question/Problem Description
How to use encryption with the Connect for ODBC 7.1 SQL Server Wire Protocol driver
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
Set the driver connection option "Encryption Method". The method the driver uses to encrypt data sent between the driver and the database server. If the specified encryption method is not supported by the database server, the connection fails and the driver returns an error.

Valid Values 0 | 1 | 6 | 7
If set to 0 (No Encryption), data is not encrypted.
If set to 1 (SSL), data is encrypted using SSL. If the server supports protocol negotiation, the driver and server negotiate the use of TLS v1, SSL v3, or SSL v2 in that order.
If set to 6 (RequestSSL) - The login request and data are encrypted using SSL if the server is configured for SSL. If the server is not configured for SSL, an unencrypted connection is established.
If set to 7 (LoginSSL) - The login request is encrypted using SSL regardless of whether the server is configured for SSL.The data is encrypted using SSL if the server is configured for SSL, and the data is unencrypted if the server is not configured for SSL.

This option can only be set to 1 when Authentication Method is set to 1.

Default 0 (No Encryption)
 
Workaround
Notes
For additional information refer to the Progress DataDirect Connect for ODBC User's Guide
The follow 2 sections of this documentation contain useful information on encryption:
- Drivers for 32-Bit and 64-Bit Platforms, SQL Server Wire Protocol driver: Connection Option Descriptions
- Reference: SSL Encryption Cipher Suites
Last Modified Date4/1/2016 2:25 PM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.


Copyright © 2022 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, Ipswitch, Chef, Kemp, Flowmon and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.

Terms of Use Privacy Center Security Center Trademarks License Agreements Code of Conduct Careers Offices
Do Not Sell My Personal Information