Is it possible to create a connection pool to an instance, but per request, change the DB it uses for the query?
I have a Saas Application with many DB's on a single instance. A given request needs to connect the user to their specific DB.
Since connections are per server, not DB, this seems that it should be supported?
Is it possible to create a connection pool to an instance, but per request, change the DB it uses for the query? I have a Saas Application with many DB's on a single instance. A given request needs to connect the user to their specific DB. Since connections are per server, not DB, this seems that it should be supported?