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

What is meant by OSI model?

0 Answers  


I would like to build in Southern Ohio, iIn a forest, some sun, lots of shade and some damp conditions. What would be some options for building green in these conditions?

1 Answers  


how to decide the number of columns, size and distance between columns for a 3 storied building of size 30x29 feet flinth area.

3 Answers   Civil Service,


One House is being constructed by an Civil Engg. all pillars are as per structure, but north side there should be 4 pillars among two at back side were 6" inside from the border and remaining two comes front were placed 1'6" inside. is it ok as per vaastu, else if i alter the alignment what would be the best idea, kindly help me.

0 Answers  


What's the best strategy to retroactively remodel to be greener?

1 Answers  


Why was it important to have large stain glass in the Gothic Cathedrals? How did these churches help the Catholic Church meet it's goals?

2 Answers  


If igloos and golf balls have any relation to the structure of domes, if so which were made first? and when were they supposedly invented?

1 Answers  


Green building has many positive effects on the environment. What are the most significant environmental benefits?

1 Answers  


what is an IDOC?Why do we use them? how do we process them? what is meant by RFC in middleware?

1 Answers  


how to know low voltage and high voltage ranges for electrical machinery ?

0 Answers  


what cut of marks in cgl2010 tier2

0 Answers  


What is meant by fetch and execute cycle in cpu operations

0 Answers  


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