The main issue is suppose i have two databases and when
user wants data for last 10 years data,it has to connect to
one database and if user wants data for the past 1 year,it
has to connect to the other database.like that .can i
create two data sources in one properties file.is it
possilbe.if so provide me the explaination.Thanks in
advance.



The main issue is suppose i have two databases and when user wants data for last 10 years data,it ..

Answer / vamshi krishna

from .net technology point of view, u can use multipls
connectionstrings to connect to the database.you can define
that in web.config file under appSettings as follows....

<connectionStrings>
<clear/>
<!--Report Data base Connection String -->
<add name="ReportingConnection"
connectionString="Server=192.168.1.13;Database=Pegasus;UID=p
egasus;PWD=pegasus;Pooling=true;Max Pool
Size=300;Connection Timeout=60"/>
<!-- Data base Connection String to the
pegasus admin database -->
<add name="PegasusAdminConnection"
connectionString="Server=192.168.1.13;Database=Pegasus;UID=p
egasus;PWD=pegasus;Pooling=true;Max Pool
Size=300;Connection Timeout=60"/>
<!-- Data base Connection String to the
pegasus course database (admin database course database
role. so, same as admin db conn string)-->
<add name="PegasusDBConnection1"
connectionString="Server=192.168.1.13;Database=Pegasus;UID=p
egasus;PWD=pegasus;Pooling=true;Max Pool
Size=300;Connection Timeout=60"/>
<!-- Data base Connection String to the
pegasus course 1 database -->
<add name="PegasusDBConnection2"
connectionString="Server=192.168.1.13;Database=Pegasus;UID=p
egasus;PWD=pegasus;Pooling=true;Max Pool
Size=300;Connection Timeout=60"/>
<!-- Data base Connection String to the
pegasus course 2 database -->
<add name="PegasusDBConnection3"
connectionString="Server=192.168.1.13;Database=Pegasus;UID=p
egasus;PWD=pegasus;Pooling=true;Max Pool
Size=300;Connection Timeout=60"/>
</connectionStrings>

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Architecture Design AllOther Interview Questions

1. What are the three services offered by GSM? Explain each of them briefly.

1 Answers   Nokia,


What is difference between Stracture of DBMS & Architecture of DBMS

1 Answers   KJ,


why you want to become artictecture

0 Answers   JP Group,


Have you heard about any earth bag project implemented in Poalnd ? I have some doubts if our climate is suitable for this kind of system.

0 Answers  


give maaterial requesion for 6x3x1 Mcube machnine foundation

1 Answers   MAHINDRA,






Why did the wall of Romanesque Churches have to be so thick?

0 Answers  


What is the difference between (with what type of material they are made of)RAM cells and Cache memory cells

2 Answers   MIT,


Who can give me Stracher Design for my plan For Coloum Position. Please call me 9921761702

0 Answers  


Is there any structure that you've been in that it was difficult to leave?

0 Answers  


What is meant by OSI model?

0 Answers  


Iam commiting an argument that postmodern architecture is copied. In particular I am researching into the structure of domes. If you could give me any advise or references to back my argument it would be much appreciated.

1 Answers  


How i can calculate material for 1000 sq foot plot.

0 Answers  


Categories
  • Interior Design Interview Questions Interior Design (21)
  • Architecture Design AllOther Interview Questions Architecture Design AllOther (185)