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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.