15 SQLSERVER
============================================================================== Magnitude Simba SQL Server ODBC Data Connector Release Notes ==============================================================================
The release notes provide details of enhancements, features, known issues, and workflow changes in Simba SQL Server ODBC Connector 1.5.23, as well as the version history.
1.5.23 =======================================================================
Released 2023-10-12
Resolved Issues The following issue has been resolved in Simba SQL Server ODBC Connector 1.5.23.
- [MSSQL-948] When connecting to failover cluster with readonly Application_Intent, the connection fails.
Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application.
[MSSQL-753] When applications run a query on local temporary tables with Prepare and Execute, the connector returns an error.
This is a limitation of SQL Server. Prepared statement execution on local temporary tables is not supported. As a workaround, applications should call SQLExecDirect when working with local temporary tables.
The SQL_VARIANT data type is not supported.
The connector exposes the SQL_VARIANT data type as SQL data type -150.
The installer for the macOS version of the connector 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 established workflows for the connector.
1.5.19 ————————————————————————
[MSSQL-944] Removed support for Visual Studio 2013
Beginning with this release, the connector no longer supports Visual Studio
- For a list of supported Visual Studio versions, see the Installation and Configuration Guide.
[MSSQL-944] Removed support for multiple operating systems
Beginning with this release, the connector no longer supports the following operating systems:
- Windows 8.1
- CentOS 6
- macOS 10.13
For a list of supported operating systems, see the Installation and Configuration Guide.
1.5.8 ————————————————————————
[MSSQL-723][MSSQL-853] Removed support for earlier versions of operating systems
Beginning with this release, the connector no longer supports the following operating systems:
- RedHat Enterprise Linux (RHEL) 6
- CentOS 6
- Ubuntu 14
For information about supported operating systems, see the Installation and Configuration Guide.
1.5.5 ————————————————————————
[MSSQL-722][MSSQL-783] Removed support for earlier versions of operating systems
Beginning with this release, the connector no longer supports the following operating systems:
- Windows 7 SP1
- Windows Server 2008 R2 SP1
- macOS 10.12 “Sierra”
- SLES 11
- Debian 8
For information about supported operating systems, see the Installation and Configuration Guide.
1.5.1 ————————————————————————
SSL 3.0 is no longer supported
Beginning with this release, the connector does not support SSL 3.0. For information about the supported SSL/TLS versions and instructions for configuring encryption, see the Installation and Configuration Guide.
1.5.0 ————————————————————————
Microsoft SQL Server 2008 and 2008r2 no longer supported
Beginning with this release, the connector does not support SQL Server 2008 and 2008r2. For information about the supported SQL Server versions, see the Installation and Configuration Guide.
1.4.11 ———————————————————————–
Microsoft SQL Server 2005 no longer supported
Beginning with this release, the connector does not support SQL Server
- For information about the supported SQL Server versions, see the Installation and Configuration Guide.
1.4.7 ————————————————————————
Minimum TLS Version
Beginning with this release, the connector requires a minimum version of TLS for encrypting the data store connection. By default, the connector requires TLS version 1.2. This requirement may cause existing DSNs and connection strings to stop working, if they are used to connect to datastores 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.5.19 ———————————————————————–
Released 2023-07-18
Enhancements & New Features
[MSSQL-939] Updated macOS Support
On macOS, the connector is now a Universal driver that natively supports Apple Silicon M1. For security best practices, it is suggested to keep both the connector and OS updated.
[MSSQL-944] Updated third-party libraries
The connector now uses the following third-party libraries:
- Expat 2.5.0 (previously 2.4.6)
- ICU 71.1 (previously 58.3)
- OpenSSL 3.0.9 (previously 1.1.1)
- SEN SDK 10.2 (previously 10.1)
- Expat 2.5.0 (previously 2.4.6)
1.5.13 ———————————————————————–
Released 2022-12-16
Resolved Issues The following issues have been resolved in Simba SQL Server ODBC Connector 1.5.13.
[MSSQL-887] On RStudio, when executing a stored procedure, the connector returns a “Invalid Cursor State” error.
[MSSQL-884] On macOS, the SQL Server ODBC connector installer does not populate odbcinst.ini.
[MSSQL-885][MSSQL-900] On RStudio, when connecting to SQL Server with application_intent=‘readonly’, the connector displays a 5701 warning instead of the actual error.
1.5.10 ———————————————————————–
Released 2021-10-30
Resolved Issues The following issue has been resolved in Simba SQL Server ODBC Connector 1.5.10.
- [MSSQL-875] In some cases, when inserting data into a text column, the connector becomes unresponsive.
==============================================================================