I need to connect MariaDB to SSIS for a project. I downloaded the 32-bit MySQL ODBC driver because my MS VS is also 32-bit. I connected to the server where MariaDB is installed using this driver. The driver is configured both in User DSN and System DSN. No errors occur when creating the connection in the Connection Manager, and when setting up the ODBC Destination, the list of tables from the MariaDB database appears, which means the connection is established. However, when running the package, the following errors occur:

1. There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.
2. Execute SQL Task: Failed to acquire connection "connection_name". Connection may not be configured correctly or you may not have the right permissions on this connection.

The user specified in the database connection is an administrator.