Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

IIS connection strings, application pools.

Posted on 2007-12-03
5
196 Views
Last Modified: 2010-04-06
I have a website that will connect to a different database depenedent on who logs in. So if customer A logs in it sets the connetion string to Customers A's db. If Customer B logs in it sets the connection string to customer B's db. Each customer goes to their own virtual dir. Customer A will go to www.site.com/customerA and customer B will go to www.site.com/customerB. each virtual dir is also running in it's own application pool. based on whe virtual directory they are in, when login is clicked we go to a customer db and look up the connection string for that virtual directory. we then set the connection string in the dataclass to the connection that we get from the customer db. This has seemed to be working. We have certain screens that auto refresh every 60 secs to show any new data. Today we had a customer call and say they were seeing other customers data when the page would auto refresh. after another refresh it would go back to their data. I doesn't happen everytime either. They said it happened once and then happened again an hour or so later. Is there a flaw in our design? Is there something I can do to figure this out? Should I do something entirely different? Thanks for your help.
0
Comment
Question by:lyptus
  • 3
  • 2
5 Comments
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 20401473
Hmm, did you create multiple application pools or different application names for each virtual directory?  The 'Create' button on the virtual directory doesn't create a new application pool.  It creates an application name but that is not an application pool.  Many applications can run within one application pool but they will share memory.
0
 

Author Comment

by:lyptus
ID: 20402893
I did create a  new application pool for each virtual directory. I created them under the application pool directory and then set each virtual directory to it's own application pool in the properties of the virtual directory.
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 20455538
Hmm.  I wonder if it's a cookie problem that.  Are you using cookies to manage your sessions?
0
 

Author Comment

by:lyptus
ID: 20456962
I think we found the problem. It had to do with the cache. Someone had been looking at another account on this computer. The data it was showing was not live data.  So I assumed it was pulling the page from the cache memory. We deleted all temp internet files and we haven't seen the problem again, so far. Knock on wood.
0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 500 total points
ID: 20460062
Ah, for testing and development I always set IE to empty the cache and also set the HTTP headers to expire immediately in IIS for the website.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PHP7 and Sql Server Windows 2008 R2 13 204
Active Directory uninstall Windows 2008 R2 6 96
FTP Directory Permissions 3 37
IIS - one site that hosts many HTTPS domains? 3 46
If I have to fix slow responding website my first thoughts are server side optimizations: the database may not be optimized or caching is not enabled, or things like that. We often overlook another major part of our web application: the client. We o…
Developer tools in browsers have been around for a while, yet they are still heavily underused by developers. Developers still fix html or CSS then refresh page to see effect, or they put alert or debugger in JavaScript and then try again and again …
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question