asked on

Webapp needs to beable to use 1 of 4 database, depending a users choice

I am building an webapp for data entry. This will be on the companies intranet all over the world, which is divided in to four regions. A user will beable to pick one regions(database) complete their tasks and switch to a different region (database) and work in that environment. I am not sure how to do this. I am thinking I need 4 different .ini files for the different connection strings. Ihave the user interface as four bottons, the user clicks their region and goes on from there. Any iedas?

thanks

6784

ASKER CERTIFIED SOLUTION

LandyJ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

6784

ASKER

Could you show me an example,just to make it worth 300 points
thanks

LandyJ

Private RegionalConnectStr As String = ""

Private Sub btnRegion1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegion1.Click
Session("MyConnectStr") = "<connect string1>"
End Sub

Private Sub btnRegion2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegion2.Click
Session("MyConnectStr") = "<connect string2>"
End Sub

Private Sub btnRegion3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegion3.Click
Session("MyConnectStr") = "<connect string3>"
End Sub

Private Sub btnRegion4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegion4.Click
Session("MyConnectStr") = "<connect string4>"
End Sub

Then, on all subsequent pages:

Dim db As ADODB.Connection
db.ConnectionString = Session("MyConnectStr")

Hope that helps,
Landy