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 Posted / 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 View All Answers
what is the role of an architect
what type of mapping is most used in maya production house?
what is the rate of 4000sqft rate, with material tile plumbing all work with plinth? Pl. Send ans. Yourlifeme@indiatimes.com
Means of interrupt in cpu operations?
I am architecture student. What type of foundation is preferred in Alluvial soil ? where the soil texture is sandy loam...and also which type of foundation is used for steel structure which will be for 6 story building design
what advice do you have for Architectural Draughtsmanship student who wish to became architects?
What feature is unique to the Hagia Sophia?
. A BSC can contain ___________ number of BCF packs.
Why did the wall of Romanesque Churches have to be so thick?
difference between action and collaboration in object oriented designing and modeling
Noisy laptop My Toshiba Laptop, Model: Satellite L355-S7905 is making from time to time ugly noise like sparks, not to mention the sound of the fan. What shall I do?
Who is responsible for territory? can you please help me in getting the answer for this
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.
ssc cgl 2010 may tax assistant ki cut of kya hogi
list the structural elements and their functions of frame structure.