Conditional database connection (ODBC)

Hi,
How I can manage multiple connection string for multiple database connection(with different ODBC connections) while my database and all table in each database are exactly same but the data contents changes.
So if we start ASP Runner applications it should ask which company you want to log in and then accordingly it should use the connection string.
Thanks

I'd imagine you would have to pull out dbconnection include from dbcommon then redefine strconnection with a session var else have one application but in multiple directories then in the front end or entrance url add a redirect in login asp event based on values of company name

• if you have a table of employees with company name you could do a lookup of company name and redirect during login

Thanks Clig, I will try this way

I'd imagine you would have to pull out dbconnection include from dbcommon then redefine strconnection with a session var else have one application but in multiple directories then in the front end or entrance url add a redirect in login asp event based on values of company name

• if you have a table of employees with company name you could do a lookup of company name and redirect during login