473,683 Members | 3,702 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Using Single Database for state w/ multiple web apps

We have multiple ASP.Net web apps in development. As a standard we
are looking to go with SQL Server to hold state information.

Can we have the multiple apps all point to a single State DB? Or do we
need to install multiple instances of the State database on to the SQL
Server (one for each Web app)?

It would seem that you could run into troubles pointing several web
apps at the same DB, because you would introduce the possibility (a
remote possibility granted) of duplicating the state's key..

Thanks
jeffpriz
Nov 18 '05 #1
4 2317
je******@yahoo. com (Jeff) wrote in news:cd5d6d81.0 410141235.1b013 4e5
@posting.google .com:
It would seem that you could run into troubles pointing several web
apps at the same DB, because you would introduce the possibility (a
remote possibility granted) of duplicating the state's key..


How are you generating the key?

There are several ways to generate unique keys.

--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 18 '05 #2
Hi Jeff,

I do this. I always have users log in though and then they can move from
app to app, server to server. The best thing to do is have all apps use a
web service to provide state support. If people do not need to be logged in
then you can still use this but I would still utilize the shared web
service, that way keys should never be duplicated. And if you are using an
Idntity field in your SQL table then you should never have a duplicated key.
Good luck! Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"Jeff" <je******@yahoo .com> wrote in message
news:cd******** *************** ***@posting.goo gle.com...
We have multiple ASP.Net web apps in development. As a standard we
are looking to go with SQL Server to hold state information.

Can we have the multiple apps all point to a single State DB? Or do we
need to install multiple instances of the State database on to the SQL
Server (one for each Web app)?

It would seem that you could run into troubles pointing several web
apps at the same DB, because you would introduce the possibility (a
remote possibility granted) of duplicating the state's key..

Thanks
jeffpriz

Nov 18 '05 #3
Thanks for the reply...

So should i take away from your response, that I would not be able to
simply point both App's session state at the one database?

Can I point 2 app's session state there without troubles? or do i have
to go through a service to handle state.

Also, i'm confused by your suggestion of using an Identity field..
I'm not sure off-hand how the InstallPersistS QLState.sql sets up the
tables, but I doubt I'd get too far by trying to re-work that
Database.

I just want to keep session state for 2 apps on a single Session db.

jeffpriz
"Ken Dopierala Jr." <kd*********@wi .rr.com> wrote in message news:<#U******* ******@TK2MSFTN GP15.phx.gbl>.. .
Hi Jeff,

I do this. I always have users log in though and then they can move from
app to app, server to server. The best thing to do is have all apps use a
web service to provide state support. If people do not need to be logged in
then you can still use this but I would still utilize the shared web
service, that way keys should never be duplicated. And if you are using an
Idntity field in your SQL table then you should never have a duplicated key.
Good luck! Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"Jeff" <je******@yahoo .com> wrote in message
news:cd******** *************** ***@posting.goo gle.com...
We have multiple ASP.Net web apps in development. As a standard we
are looking to go with SQL Server to hold state information.

Can we have the multiple apps all point to a single State DB? Or do we
need to install multiple instances of the State database on to the SQL
Server (one for each Web app)?

It would seem that you could run into troubles pointing several web
apps at the same DB, because you would introduce the possibility (a
remote possibility granted) of duplicating the state's key..

Thanks
jeffpriz

Nov 18 '05 #4
Hi Jeff,

Sorry, I don't know the answers. I thought you were trying to do some
custom state thing where you have multiple apps that work together and
people move in and out of. I would give it a try and see what happens.
Here is the field that the .SQL creates to identify the session:

SessionId CHAR(32) NOT NULL PRIMARY KEY,

My guess is that it is holding a GUID. GUIDs are rarely duplicated and it
sounds like this is using a Windows Service. So if both apps are using that
same service (i.e. they are on the same web server) I would imagine that the
service would make sure that it didn't duplicate GUIDs and pointing to the
same DB would be fine. If they were on seperate servers, then the instances
of the Windows Service handling this wouldn't know about each other and
therefore couldn't coordinate the usage of unique GUIDs. Then again, if the
Windows Service first queries the DB to make sure the GUID it generates
isn't in use then running the apps on muliple servers pointing to the same
DB should work fine also.

Anyway, as you can see I have no idea what I'm dealing with here so I can't
give you an answer. Hopefully this is enough information to let you maybe
make another post asking specific questions to resolve this. Good luck!
Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"Jeff" <je******@yahoo .com> wrote in message
news:cd******** *************** ***@posting.goo gle.com...
Thanks for the reply...

So should i take away from your response, that I would not be able to
simply point both App's session state at the one database?

Can I point 2 app's session state there without troubles? or do i have
to go through a service to handle state.

Also, i'm confused by your suggestion of using an Identity field..
I'm not sure off-hand how the InstallPersistS QLState.sql sets up the
tables, but I doubt I'd get too far by trying to re-work that
Database.

I just want to keep session state for 2 apps on a single Session db.

jeffpriz
"Ken Dopierala Jr." <kd*********@wi .rr.com> wrote in message

news:<#U******* ******@TK2MSFTN GP15.phx.gbl>.. .
Hi Jeff,

I do this. I always have users log in though and then they can move from app to app, server to server. The best thing to do is have all apps use a web service to provide state support. If people do not need to be logged in then you can still use this but I would still utilize the shared web
service, that way keys should never be duplicated. And if you are using an Idntity field in your SQL table then you should never have a duplicated key. Good luck! Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"Jeff" <je******@yahoo .com> wrote in message
news:cd******** *************** ***@posting.goo gle.com...
We have multiple ASP.Net web apps in development. As a standard we
are looking to go with SQL Server to hold state information.

Can we have the multiple apps all point to a single State DB? Or do we
need to install multiple instances of the State database on to the SQL
Server (one for each Web app)?

It would seem that you could run into troubles pointing several web
apps at the same DB, because you would introduce the possibility (a
remote possibility granted) of duplicating the state's key..

Thanks
jeffpriz

Nov 18 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

112
10317
by: Andy | last post by:
Hi All! We are doing new development for SQL Server 2000 and also moving from SQL 7.0 to SQL Server 2000. What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000? Please, share your experience in using IDENTITY as PK .
3
9240
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works only exporting to single worksheet. but i need to export data to multiple worksheets. it is very urgent to us. so please help me in code.
121
10063
by: typingcat | last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode support IDEs are DreamWeaver 8 and Zend PHP Studio. DreamWeaver provides full support for Unicode. However, DreamWeaver is a web editor rather than a PHP IDE. It only supports basic IntelliSense (or code completion) and doesn't have anything...
9
23071
by: Abhishek Srivastava | last post by:
Hello All, In IIS 6.0 We have a concept of worker processes and application pools. As I understand it, we can have multiple worker process per appliction pool. Each worker process is dedicated to a pool. If I assign only one application to a applicaton pool and have multiple worker processes assigned to that pool. Will my application be processed by many worker processes?
10
7912
by: Anthony Williams | last post by:
Hi gang, This one looks like a bug :o( As you may or may not know, setting session management in web.config to use cookieless sessions causes the ASP.NET runtime to munge a session ID into the URL, in the format http://yourapplicationpath/(Session.SessionID)/... which saves numerous headaches when it comes to storing state across page requests and sessions.
3
1520
by: masoud bayan | last post by:
Hi, We have 3 different web applications on three different websites (and domains). Now we want to make it possible for users to login in each of these applications and can navigate to other applications without authenticating. So generally we need to have a shared session across applications (a single sign-on).
2
1382
by: Bob | last post by:
I would like to use integrated security for DB connection for my ASP.NET applications. Since these apps have different databases (SQL Server), I want each app to be able to access its own database. Say if I have 10 apps, I'd need 10 logins, one login for each DB. Now throw in the windows integrated security, I need 10 windows account. However, in order to run an ASP.NET app under a certain identity, it has to have its own application...
4
2714
by: Jai | last post by:
Hi, I have a problem related to Login System. I am developing 3 websites for some institution.Now they want that if anybody had sign up for there site1.com(say), than he or she should be able to sign in for site2.com and site3.com. hence, if user has sign up for the membership of site1.com than he/she should automicallly become the member of site2.com and site3.com.
4
6494
by: TechnoAtif | last post by:
Hi ALL I have entered some array values using checkboxes into mysql database through a form. Next iam creating a searchpage where all those cateogories inserted through checkboxes has to be retrieved using list/menu box. When i check only a single checkbox to insert the checked category ,selecting that category through list box gives out the entire data of the user corresponding to that category. However when i check multiple checkboxes and...
0
8568
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8504
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8922
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8771
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7582
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6429
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4519
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2195
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1921
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.