- Overview
- Cryptography
- Database
- Java
- Python
- WebAPI
Release notes
Release date: September 26, 2024
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.
- A
You have an error in your SQL syntaxerror occurred when using the Insert activity to add data in a MySQL database. - Oracle store procedures with
OracleRefCursorno longer throw exceptions. - Resolved loading library errors during the use of UNC paths and ensured the
dsnkeyword is now supported in Windows projects.
Release date: September 1, 2022
- 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.
- Converting a project that has activities with the
System.Data.SqlClientconnection option from Windows - Legacy to the Windows compatibility throws an execution error unless you change the connection option toMicrosoft.Data.SqlClient. - Similarly, converting a Windows - Legacy project that has activities with the
MySql.Data.MySqlClientconnection throws an error unless the connection option is set toSystem.Data.Odbc(the MySQL ODBC Driver needs to be installed on the machine using the Microsoft ODBC Data Source Administrator).
Release date: January 13, 2021
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.
- 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.
- 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 errorwhen calling stored procedures with out parameters. We have fixed the way in which the ODBC driver is called to prevent this error.
Release date: October 8, 2018
Release date: March 27, 2018
This release brings new properties for the Start Transaction, Execute Query, and Execute Non Query activities.
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.
