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 2 2329
Don't multipost. See asp.db group.
Ray at work
"hourman" <sd***********@7fdfster.com> wrote in message
news:3f***********************@newscene.com... 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
In article <Od**************@tk2msftngp13.phx.gbl>, "Ray at <%=sLocation%>" <as*@me.forit> wrote: Don't multipost. See asp.db group.
Ray at work
"hourman" <sd***********@7fdfster.com> wrote in message news:3f***********************@newscene.com... 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jim Cobban |
last post by:
I am trying to create a web page in which the contents of one selection list
depends upon which element in another selection list is chosen, but where
the information to populate the first...
|
by: Ed Stevens |
last post by:
A tale of woe, and a question . . .
Last week my boss said to me "we've installed DB2 Connect on this
Solaris box. Make it work."
Now, I've barely seen DB2 Connect on Windows, having fumbled...
|
by: Lyn |
last post by:
Hi,
I am working on a genealogy form. The only table (so far) lists everybody
in the family, one record per person. Each record has an autonum ID.
The parent form (frmMainForm) displays the...
|
by: Galina |
last post by:
Hello
I have 6 dependent list boxes on my ASP page:
Faculty;
Lecturer;
Course;
Course occurrence;
Group;
Week commencing date.
When faculty is selected, lists of lecturers and...
|
by: Christian Ista |
last post by:
Hello,
I have 2 questions :
1. On an ASP.NET page I have several controls (5 TextBox, 1 Dropdown and 1
button)
Only the dropdown is AutoPostBack = true, the TextBox are SingleLine
When I...
|
by: thegame |
last post by:
Filling One DataGrid Based on Selection from Another DataGrid - Both in
Separate User Controls
Hello, I have an interesting dilemma.
I have an ASPX page with two user controls (two ASCXs). ...
|
by: Chris |
last post by:
I have a meetings section I'm developing on our intranet. Using PHP/MySQL.
Meeting info and Meeting docs reside on 2 related tables in the db. Users
may want to upload anywhere from 1 to 10 or...
|
by: Italian Pete |
last post by:
Hi,
I have a search bar as a User Control sitting on a Page. The asp web control
search button has its OnClick event set to a method "Search" which sets a
bool isSearch to true.
When I try to...
|
by: angelicdevil |
last post by:
i have listbox 1 which displays status , based on selection of status listbox 2 displays usernames. and based on username selected the textbox displays the email id.
its working fine till...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |