Is there a way of changing the username and password used to connect to the db in a connection pool, or do i have to create a new connection pool with the new username and password.

I do not want to hard code the connection string thats why i want to do it with a connection pool, as teh connection pool names will not be changing, but the connection string will change when the app gets installed on different machines.

Read the connection string from a config file, then load the connection string at runtime