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
Why were the Gothic Churches able to have large stain glass windows?
ssc cgl 2010 may tax assistant ki cut of kya hogi
How is BP in CRM synchronised with R/3? What r all the steps involved?can we do the partner determination based on SALES AREAS?
list the structural elements and their functions of frame structure.
Is there any symbolic or cultural significance behind the structure of the buildings you are observing?
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.
I have completed my Diploma in architectre from Gujarat Technical board. I would like to do a Postal degree.Could you tell me which univercity will help me.How can i regester my name in IIA.
What personal quality is important to be an architect?
Is this house typical of the houses of this community? What makes it typical or atypical?
what is the rate of 4000sqft rate, with material tile plumbing all work with plinth? Pl. Send ans. Yourlifeme@indiatimes.com
How to calculate stabilizer for a machine
what cut of marks in cgl2010 tier2
rate for 5" thk rcc slab using rebarring in pune
describe an achievement highlighting your approach to a problem you faced as well as the solution you developed
The telecommunications offered by the GSM PLMN may be divided into three main groups.what is it?