13 SQLSERVER

============================================================================== Simba SQL Server ODBC Driver Release Notes ==============================================================================

The release notes provide details of enhancements, features, and known issues in Simba SQL Server ODBC Driver 1.4.13, as well as the version history.

1.4.13 =======================================================================

Released 2018-11-22

Enhancements & New Features

[MSSQL-520] NTLM support on Linux

You can now configure the Linux driver to authenticate the connection using the NTLM protocol. For more information, see the Installation and Configuration Guide.

Known Issues The following are known issues that you may encounter due to limitations in the data source, the driver, or an application.

The SQL_VARIANT data type is not supported.

The driver exposes the SQL_VARIANT data type as SQL data type -150.
The installer for the macOS version of the driver does not alert the user when it fails to write to odbcinst.ini.

When the installer fails to write to the odbcinst.ini configuration file, instead of alerting you of the error, the installer reports the event in a log file.

Workflow Changes ============================================================

The following changes may disrupt workflows from earlier versions.

1.4.11 ———————————————————————–

Microsoft SQL Server 2005 no longer supported

Beginning with this release, the driver does not support SQL Server 2005.

1.4.7 ————————————————————————

Minimum TLS Version

Beginning with this release, the driver requires a minimum version of TLS for encrypting the data store connection. By default, the driver requires TLS version 1.2. This requirement may cause existing DSNs and connection strings to stop working, if they are used to connect to data stores that use a TLS version earlier than 1.2.

To resolve this, in your DSN or connection string, set the Minimum TLS option (the Min_TLS property) to the appropriate version of TLS for your server. For more information, see the Installation and Configuration Guide.

Version History ==============================================================

1.4.12 ———————————————————————–

Released 2018-10-30

Enhancements & New Features

[MSSQL-608] Upgrade to OpenSSL 1.1.0i

The driver now uses OpenSSL 1.1.0i for encryption of data.
Updated system requirements

The driver no longer supports Microsoft SQL Server 2005. For the supported versions of SQL Server, see the Installation and Configuration Guide.

1.4.11 ———————————————————————–

Released 2018-09-28

Resolved Issues The following issue has been resolved in Simba SQL Server ODBC Driver 1.4.11.

[MSSQL-593] Driver requires a minimum TLS version to be used for the connection, even when TLS encryption is not enabled.

This issue has been resolved. The driver now only requires a minimum TLS version to be used if the connection is encrypted by the TLS protocol, which is the expected behavior.

1.4.10 ———————————————————————–

Released 2018-09-17

Resolved Issues The following issue was resolved in Simba SQL Server ODBC Driver 1.4.10.

[MSSQL-595] When authenticating the connection using the Kerberos protocol, the driver fails to infer the server principal name based on the specified Server and Port values.

1.4.9 ————————————————————————

Released 2018-08-14

Resolved Issues The following issue was resolved in Simba SQL Server ODBC Driver 1.4.9.

[MSSQL-591] On Windows, the driver prompts you to provide your user name and password for authentication even when it is configured to use Kerberos authentication.

1.4.8 ————————————————————————

Released 2018-07-27

Enhancements & New Features

[MSSQL-583] Support for SSLv3

You can configure the driver to use SSLv3 to connect with the server. For more information, see the Installation and Configuration Guide.

1.4.7 ————————————————————————

Released 2018-07-18

Enhancements & New Features

[MSSQL-575] Support for configuring minimum TLS version

You can now specify the minimum version of TLS that the driver must use to connect to the SQL Server. For more information, see the Installation and Configuration Guide.

1.4.6 ————————————————————————

Released 2018-06-29

Enhancements & New Features

[MSSQL-567] Authentication configuration options simplified

The configuration options for enabling Kerberos and NTLM authentication have been simplified. For information about how these authentication methods are now configured, see the Installation and Configuration Guide.

Workflow Change

The following change may disrupt workflows from earlier versions.

Changes to authentication configuration options

As of this release, the way that the driver uses the Trusted_Connection and Integrated Security connection properties has changed. This change might invalidate existing connections that use the Kerberos or NTLM mechanisms for authentication. You must update any connection strings or odbc.ini files that enable Kerberos or NTLM. For more information, see the Installation and Configuration Guide.

1.4.5 ————————————————————————

Released 2018-05-14

Enhancements & New Features

[MSSQL-561] Updated log file name and error message prefix

The log file that the driver generates when logging is enabled has been renamed from SimbaSqlServerODBC.log to simbasqlserverodbcdriver.log. Additionally, the error message prefix that the driver returns has been changed from [Simba][SqlServerOBC] to Simba.

Resolved Issues The following issue was resolved in Simba SQL Server ODBC Driver 1.4.5.

[MSSQL-554] When installed on macOS, the driver might fail to be recognized by the system.

This issue has been resolved. Before, this issue occurred because of a mismatch between the name of the driver library file and the file name referenced by the odbcinst.ini file. The driver now consistently uses the same library file name (libsqlserverodbc_sbu.dylib), ensuring that the installed driver can be recognized by the system.

1.4.4 ————————————————————————

Released 2018-04-30

Enhancements & New Features

Upgrade to OpenSSL 1.1.0h

The driver now uses OpenSSL 1.1.0h for encryption of data.

Resolved Issues The following issue was resolved in Simba SQL Server ODBC Driver 1.4.4.

The password is displayed in clear text in the Windows Registry.

This issue has been resolved. The driver now encrypts the password when saving it in the Windows Registry.

1.4.3 ————————————————————————

Released 2018-04-05

Enhancements & New Features

Internal driver improvements

The driver has been updated with minor internal improvements.

1.4.2 ————————————————————————

Released 2018-03-23

Enhancements & New Features

Support for NTLM authentication on Windows

You can now authenticate the connection using the NTLM protocol when you use the Windows version of the driver.

Resolved Issues The following issue was resolved in Simba SQL Server ODBC Driver 1.4.2.

In some cases, the driver returns error messages with an incorrect branding prefix.

This issue has been resolved. The driver now consistently returns error messages with the correct branding prefix, which is [Simba][SqlServerODBC].

1.4.1 ————————————————————————

Released 2018-01-30

Resolved Issues The following issues were resolved in Simba SQL Server ODBC Driver 1.4.1.

During query execution, in some cases the system message “Error creating temporary swap file name” may be displayed.
Driver returns misleading error message when the connection fails due to incorrect connection information being specified.

1.4.0 ————————————————————————

Released 2018-01-11

Enhancements & New Features

Internal driver improvements

The driver has been updated with minor internal improvements.

==============================================================================