Thank you very much for the information @jrmuirhead ! Please bear with me as I have a limited knowledge on these configurations (and english is not my native language so there might be some mistakes in there )
I'll give more detail on the issue that I forgot to point out initially. I've actually run Step 1 and followed up all the instructions on setting up the odbc as instructed here: 'Setting up ODBC Drivers'
I've also downloaded the odbc driver manager 'odbcmanager.net/' as MacOS stopped providing a native application after Leopard and installed Postgres SQL Driver and also an AWS redshift from their websites. After those were installed they created the files on the mentioned locations.
I've used the odbc Manager to setup the drivers, although I haven't setup anything on User/System DSN (i thought by using odbc.ini it would already work, is it wrong?)
When using Method 2 to create a symbolic from homebrew installation I 've got the following result confirming that the driver does exist in the location specified
mkdir: /Library/PostgreSQL: File exists
mkdir: /usr/local/opt/psqlodbc: File exists
mkdir: /Library/PostgreSQL/psqlODBC: File exists
So it seems that both drivers exist on the correct location and are configured on the ODBC Manager. They also appear correctly on RStudio Connection pane but each gives a different error prompt message although all appear to be configured right as setup by odbcinst.ini. Do you know if there is anything that I might be missing?
Error: nanodbc/nanodbc.cpp:1021: 00000: [Amazon][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function: [Amazon][DSI] An error occurred while attempting to retrieve the error message for key 'LibsLoadErr' with message parameters ['""'] and component ID 3: Message not found in file "/opt/amazon/redshift/ErrorMessages/en-US/ODBCMessages.xml"
Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib '/Library/PostgreSQL/psqlODBC/lib/psqlodbcw.so' : file not found