I tried this step as well but still the issue is present. Due to time constraints, we decided to use another approach for this project. Thank you for your assistance. 

Looks like it does, strangely. I double-checked everything. 

Thanks Jeffrey for the reply. Unfortunately, this did not work for me. As we are on older version it is cgate.so. There was a file called cgateur64.so. I copied cgate64.so to cgate.so. The connection test does not hang but no DSN name is listed in the following dropdown.