Oracle Gateway database link to MSSQL server failed with error "Ora-28500 error with argument 523 80 {82} "

Solution:

Check and modify the .LOC file located in Gateway_Home/<gtw>/driver to get the right PATH to the ODBC library.