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.
- 1 Answers
- 4316 Views
- I also Faced
- E-Mail Answers
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 are the dimension of hollow bricks size
how i calculate steel required for r.c.c1400sqr feet slab ,what is the thickness of steel bar.
Is there any difference between interrupt and acknowledgment?
Hi i am going to attend Deputy Architect interview in Telecommunication Dept. through UPSC I dont know the type of questions they will ask. I will be very thankful if anyone could help me. Please send to my email-id ganesh_dev@rediffmail.com Please any one have experience of some other Dept., please reply me. my interview in on 10th of Nov. only 5 days left. please help.
what are the differences of software life cycle models
What is the name of the first type of building used in Christian Churches?
What were the steps to putting together a stain glass window?
RCC colums of 15"X9" each, roof height 20.5'ft, total pillars 36 nons. Span between pillar to pillar is 16/20/20 length wise and 16/14 width wise. Total Slab area 8000 sft and plinth area is 1900 sft. beams are 12"X9". kindly calculate load factor per sqft.
Australian architecture should be much the same as American architecture because they both came from British influence and were founded at about the same time. I was hoping you could give me some insight on that and tell me if I should change my hypothesis.
1 bag cement =who many seq er meters plastering (1:5)
What methods and materials would you suggests for the Mediterranean environment?
Iam studying architecture in India. I have an interest in vernacular arcjitecture. I want to specialize in that, so what are the ways for that, after graduation?
Interior Design 
