Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple databases
Message
From
25/09/2007 07:37:03
 
 
To
25/09/2007 07:19:49
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
01256575
Message ID:
01256579
Views:
14
This message has been marked as the solution to the initial question of the thread.
>Hi,
>
>Question. Supposing you're having an app with an asp interface and one frame is using say database A. Is it possible that another frame on the same page uses say database B.
>
>Someone just told me that this is difficult- close to impossible
>
>I cannot imagine this is impossible
>
>Question:
>(1) Can different frames on the same page be connected/using different databases
>(2) If yes to (1), Can one single frame use multiple databases at the same time
>
>I'd say yes to both questions, but since I'm no expert in asp.net I thought asking the question to people having more expertise
>
>A small explanation as to why yes/no would be helpful
>
>Thanks,


I don't use frames, but I do not see why not. I have more than one asp.net app using data from different databases, and from different servers for each database. We have a very large network. I have the app's data (RW) and I also have to access read-only corporate data for lookups and reports. The apps are 3-Tier (logical and physical 3-Tier). Each section of the screen, be it a GridView or an HTML Table built programmatically, gets the data from the Data Access Layer. Each DAL method (called by a web service) establishes the connection to the proper database (defined in web.config) and runs the stored procedure or query. No problem ;(we do not mix the two databases on the DataSet, just different sets for different regions of the page).

HTH


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform