Thanks for coming back to me. I have used connection in production Environment.
Let me explain you all the working & not working scenarios:
A) Connection1: localhost , Connection2: localhost
B) Connection1: localhost, Connection2 Remote server
A) Connection1: Webserver(remote) Connection2: Webserver Remote
Connection1 & Connection2 has same DB server, Different DB and Users for DB.
Connection1 is the main and it work but there are some application that use connection 2 but on its connetion it sends an error and which tries to map the connection2 on my localnetwork.
I ensure that I have assigned the correct information in both the connection.
I think it is a bug in scriptcase.
An error occurred while connecting to the database:
Connection attempt failed: SQLSTATE[HY000]  Access denied for user ‘USERNAME’@‘MyNetworkIP’ (using password: YES)
How come I get the MyNetworkIP:: my router IP, my server is hosted in UKfast and how come it tried to get my localhost?