I have developed a web site using asp.net and C#,
Iam using Microsoft enterprise library - DBfactory for establising connection with sql server 2005.
Now i want to implement the application to connect to different databases for different users.
Client A should connect to database DB1 in Server-1 Client B should connect to database DB2 in Server-2 Client C should connect to database DB3 in Server-3 . . .
For this purpose, from client i can pass connection string as a query string.
Now i dont know how to implement this, iam using enterprise library DBFactory, Please give me a solution as early as possible.
Thanks in advance,
Edited 3 Years Ago by mike_2000_17: Fixed formatting