book
Article ID: KB0073170
calendar_today
Updated On:
Description
This article defines the usage of SQL Native Client driver with Statistica when TLS 1.2 is enabled.
Note: 1. SQL Native client is not the most recommended driver. Refer to:
https://support.tibco.com/s/article/What-SQL-Server-ODBC-driver-should-be-used-when-TLS-version-1-2-is-enabled 2. TLS 1.2 is enabled by default on Windows 10, version 1507+ and Windows Server 2012+.
Resolution
The SQL Native client driver works with Statistica when TLS 1.2 is enabled. 1. Install the compatible version SQL Native Driver. Refer:
SQL Native driver 2. Under ODBC Administrator|System DSN, check the driver version for the existing Enterprise database DSN (named "SEWSS" by default). If the old driver (e.g. ODBC Driver 13 for SQL server) is in use, delete the current DSN.
Note: Before deleting, please keep a record of the DSN information such as name and description, since the information is needed in later steps.
3. Click the "Add" button to create a new DSN and select "SQL Server Native Client" as the driver.
4. Fill in the same information as the deleted DSN (name and description), and select the same SQL server database:
5. Follow the instruction to finish the DSN setup steps.
When launching Statistica, selecting the correct database in the drop-down, if necessary:
Issue/Introduction
Does SQL Native Client driver works with Statistica when TLS 1.2 enabled?