Database connections

I’m struggling to fully understand how to properly set up database connections. I have previously managed to setup a Database query that displays data in a repeat region. this works but if I access the connection details from 'Database Manager it shows an error even though tables appear under the connection indicating it has connected. If I select the connection from Globals and view connection options and test it connects ok. So why does it appear to not except the details from Database Manager?

Thanks in Advance!