I update for the community, in case someone else gets into this specific mistake.
I solved it myself.
Reading the error logs, it catches my attention, the fact that it refers to ODBC Connection:
" * at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)*"
So I went through my ODBC settings and tried to create a different connector type.
I understand that the “ANSI DRIVER” connector does not work as a “unicode driver”.
I am not so experienced as to understand the difference, but by creating the SERVER_PRE as unicode, my flow started working correctly.
I hope my experience will be useful to someone.
Aaron