The "Database: Connection is closed.." error at "Execute query" activity

Text and meaning of the error

Such an error can occur when working with the Execute query activity. The error message can look like this:

Solution

To solve this error, you need to do the following:

1. Enable TCP/IP in SQL Server Configuration Manager → SQL Server Network Configuration → Protocols for SQLEXPRESS node.

1. In the "IP Addresses" tab of the "TCP/IP Properties" page, scroll down to IPAll and clear any value present for TCP Dynamic Ports and provide the value 1433 in the TCP Port.

3. Click "Apply" and ensure to restart the SQL Service for the changes to take effect.

Cannot locate a 64-bit Oracle Client library

Description

You may encounter this error when connecting to an Oracle database:

Cannot locate a 64-bit Oracle Client library: "The specified module could not be found". See https://oracle.github.io/node-oracledb/INSTALL.html for help Node-oracledb installation instructions: https://oracle.github.io/node-oracledb/INSTALL.html You must have 64-bit Oracle client libraries in your PATH environment variable.

To avoid this error, you must specify the path to the directory with the Oracle client in the Windows environment variables.

If you do not have the Oracle client on your machine, you can download it from here.

Next, you need to open "Edit the system environment variables". You can do this by starting to type the word "variable" in the search bar:

After that, add a Path variable, which will contain the path to the directory with the Oracle client.

📘

Note: the versions of Oracle client and Oracle server must be the same.