# Release notes

> **Release date: July 22, 2025**

## v2.0.0

**Release date: July 22, 2025**

### Improvement

The connection wizard now supports the SID option when configuring the Oracle.ManagedDataAccess connection.

### Bug fix

* Connection wizard for "Oracle.ManagedDataAccess" Data Source would fail to build the correct connection string.
* Oracle connections would throw "ORA-28040: The database does not accept your client's authentication protocol; login denied" in certain scenarios.

### Breaking change

Starting with the 2.0.0 release of the Database activity package, support for the.NET 4.6.1 framework has been discontinued. As a result, this and all subsequent package versions cannot be used for Windows-Legacy projects. Restrict package usage to Windows or cross-platform projects exclusively.

Package versions released before this date continue to support .NET 4.6.1 as per the [following deprecation timeline](https://docs.uipath.com/overview/other/latest/overview/deprecation-timeline#upcoming-removals).

## v1.10.1

**Release date: July 03, 2025**

### Bug fixes

Fixed an issue that sometimes caused Database activities to throw errors when used in Studio 2023.10 or lower.

## v1.10.0

**Release date: April 07, 2025**

### Bug fix

In **Windows** projects, when **Start Transaction** or **Execute Query** activities failed inside a **Try Catch**, execution skipped the **Catch** block and proceeded directly to the **Finally** block.

## v1.9.0

**Release date: September 26, 2024**

### New features and improvements

The Database activity package is now compatible with.[NET 6 Windows](https://dotnet.microsoft.com/en-us/download/dotnet/6.0) and now supports the cross-platform project compatibility. For more information on the design experience when creating cross-platform projects, refer to [Designing Automations](https://docs.uipath.com/studio/docs/designing-automations).

For this release, we also made sure to bring minor improvements and security fixes to this package.

### Bug fixes

* A `You have an error in your SQL syntax` error occurred when using the [Insert](https://docs.uipath.com/activities/other/latest/developer/insert-data-table) activity to add data in a MySQL database.
* Oracle store procedures with `OracleRefCursor` no longer throw exceptions.
* Resolved loading library errors during the use of UNC paths and ensured the `dsn` keyword is now supported in Windows projects.

## v1.7.1

**Release date: September 26, 2022**

### Improvements

The Database activity package is now digitally signed.

## v1.7.0

**Release date: September 1, 2022**

### Bug fixes

* Certain functionalities for Azure Active Directory authentication support for SQL Server connectivity were not functioning properly.
* The Execute Query activity threw an error when executing certain queries.

### Breaking changes

* Converting a project that has activities with the `System.Data.SqlClient` connection option from Windows - Legacy to the Windows compatibility throws an execution error unless you change the connection option to `Microsoft.Data.SqlClient`.
* Similarly, converting a Windows - Legacy project that has activities with the `MySql.Data.MySqlClient` connection throws an error unless the connection option is set to `System.Data.Odbc` (the MySQL ODBC Driver needs to be installed on the machine using the [Microsoft ODBC Data Source Administrator](https://learn.microsoft.com/en-us/sql/odbc/admin/odbc-data-source-administrator?view=sql-server-ver16)).

## v1.5.0

**Release date: October 26, 2021**

### Improvements

The **Bulk Insert** and **Bulk Update** activities were added to the package.

The Database activity package is now compatible with.NET 5 Windows.

The activities in this package now support `SecureString` parameters.

## v1.4.0

**Release date: January 13, 2021**

### New features and improvements

Stored procedures run against an Oracle database now have mapped output parameters when using Execute Query. Until now, only Execute Non Query would map output arguments.

### Known issues

* MS Access 2016 32 bit does not allow concurrent connections, so trying to concurrently connect 2 activities to that version of Access produces a driver error.

### Bug fixes

* Some users encountered an error reading "Parameter 'msg': Value is too large to bind" in Oracle. We have made it so that the call to such Oracle databases is made in a way which prevents this error.
* You can now use the **Edit Query** button even when there are very long queries in the interface of the Execute Query activity.
* When using Execute Non Query on a SQL Server over ODBC, some users were getting a `The Size property has an invalid size of 0 error` when calling stored procedures with out parameters. We have fixed the way in which the ODBC driver is called to prevent this error.

## v1.3.7369.25200

**Release date: March 5, 2020**

### Bug fixes

* Fixed an issue that caused the Database activities to disappear from the Activities panel when the language in Studio was set to German.

## v1.2.6855.24218

**Release date: October 8, 2018**

### New features and improvements

The moment is finally here - the entire UiPath Platform has been localized, so that you can have a truly immersive experience, from install to design and execution. Now, besides English, you can access everything, including our online documentation, in Japanese.

## v1.1.6660.26865

**Release date: March 27, 2018**

### New feature and improvements

This release brings new properties for the Start Transaction, Execute Query, and Execute Non Query activities.

The **ExistingDbConnection** property has been added to the Start Transaction activity, which can be used to connect to a database.

The **TimeoutMS** property has been added to the Execute Query and Execute Non Query activities, enabling you to set a timeout period for queries to the database before the activity throws an exception.
