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.
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 |
What is meant by OSI model?
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?
how to decide the number of columns, size and distance between columns for a 3 storied building of size 30x29 feet flinth area.
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.
What's the best strategy to retroactively remodel to be greener?
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?
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?
Green building has many positive effects on the environment. What are the most significant environmental benefits?
what is an IDOC?Why do we use them? how do we process them? what is meant by RFC in middleware?
how to know low voltage and high voltage ranges for electrical machinery ?
what cut of marks in cgl2010 tier2
What is meant by fetch and execute cycle in cpu operations