Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > How can u connect to 1 of several dbs based on selection user makes when accessing main page

Reply
Thread Tools

How can u connect to 1 of several dbs based on selection user makes when accessing main page

 
 
hourman
Guest
Posts: n/a
 
      07-21-2003
We have a web site IIS 5 (on Win2000k) with Oracle 9i backend (Sun unix).

There is 1 user ID to oracle(APT_W3) that is used by all users (50).

We have a global.asa file that has one APP Start connection string using OLE
DB:
Application("dbConnString")="Provider=MSDAORA.1;Pa ssword='SDERSD';User
ID=APT_W3;Data Source=CCEWSDD1_new;Locale Identifier=1033;OLE DB services=-1"

The first page that a user sees asks that they select the area they want to
see (western, northern, etc) from a dropdown menu. Once they select it and
hit save they can go to other pages, session varibles indicating what area
they selected are then passed to pages. Currently all areas are in one
database.

What we want to do is have areas in separate dbs, a northern one, a western
one.etc. Each will have separate user ids (APT_W2N, APT_W3W,etc).

We want the users to have the web page presented to them where they select an
area. Based on the area they select, the appropriate conneciton string will
be used (the one in the global asa).

Is there a way to have that in the global asa? Maybe as a session
Session_OnStart? Based on the selection they made on the web page, they will
be using one of several connection strings so we can have connection pooling
 
Reply With Quote
 
 
 
 
Ray at
Guest
Posts: n/a
 
      07-21-2003
Don't multipost. See asp.db group.

Ray at work

"hourman" <(E-Mail Removed)> wrote in message
news:3f1c28a7$0$96923$(E-Mail Removed)...
> We have a web site IIS 5 (on Win2000k) with Oracle 9i backend (Sun unix).
>
> There is 1 user ID to oracle(APT_W3) that is used by all users (50).
>
> We have a global.asa file that has one APP Start connection string using

OLE
> DB:
> Application("dbConnString")="Provider=MSDAORA.1;Pa ssword='SDERSD';User
> ID=APT_W3;Data Source=CCEWSDD1_new;Locale Identifier=1033;OLE DB

services=-1"
>
> The first page that a user sees asks that they select the area they want

to
> see (western, northern, etc) from a dropdown menu. Once they select it

and
> hit save they can go to other pages, session varibles indicating what area
> they selected are then passed to pages. Currently all areas are in one
> database.
>
> What we want to do is have areas in separate dbs, a northern one, a

western
> one.etc. Each will have separate user ids (APT_W2N, APT_W3W,etc).
>
> We want the users to have the web page presented to them where they select

an
> area. Based on the area they select, the appropriate conneciton string

will
> be used (the one in the global asa).
>
> Is there a way to have that in the global asa? Maybe as a session
> Session_OnStart? Based on the selection they made on the web page, they

will
> be using one of several connection strings so we can have connection

pooling


 
Reply With Quote
 
 
 
 
hourman
Guest
Posts: n/a
 
      07-21-2003
In article <(E-Mail Removed)>, "Ray at <%=sLocation%>" <(E-Mail Removed)> wrote:
>Don't multipost. See asp.db group.
>
>Ray at work
>
>"hourman" <(E-Mail Removed)> wrote in message
>news:3f1c28a7$0$96923$(E-Mail Removed)...
>> We have a web site IIS 5 (on Win2000k) with Oracle 9i backend (Sun unix).
>>
>> There is 1 user ID to oracle(APT_W3) that is used by all users (50).
>>
>> We have a global.asa file that has one APP Start connection string using

>OLE
>> DB:
>> Application("dbConnString")="Provider=MSDAORA.1;Pa ssword='SDERSD';User
>> ID=APT_W3;Data Source=CCEWSDD1_new;Locale Identifier=1033;OLE DB

>services=-1"
>>

sorry its my 1syt post, did not know which group was best suited for question,
since it involved db, but was also asp (global asa) related.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How include a large array? Edward A. Falk C Programming 1 04-04-2013 08:07 PM
where do you run database scripts/where are DBs 'located'? John Salerno Python 21 05-18-2006 05:39 AM
IIS5 > IIS6 Aspx pages with MSAccess dbs no longer working Mark B ASP .Net 8 07-28-2005 10:08 PM
Change main window href from IE search panel, after user has left my main page? Robert Oschler Javascript 1 10-12-2004 08:34 PM



Advertisments