Release notes

v1.9.0

Release date: September 26, 2024

New features and improvements

The Database activity package is now compatible with .NET 6 Windows and now supports the cross-platform project compatibility. For more information on the design experience when creating cross-platform projects, refer to 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 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).

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.