I am working on a client/server application that has a browser frontend in ASP, business rules in VB DLLs, and a SQL Server backend.

The DSN is hardcoded in the global.asa file. I would like to pass a variable to the global file depending on who logs into our system and then set the DSN. This way we can have one site with multiple databases.

Any suggestions?