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
- 4480 Views
- I also Faced
- E-Mail Answers
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 maximum depth at which the open foundation bridge can be done
why you want to become artictecture
how much steel required for 1 sq area for swimmin pool construcion
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.
How i can calculate material for 1000 sq foot plot.
what is the use of studing architecture
how many steel rod of the cilling 10'x10'
What is meant by fetch and execute cycle in cpu operations
what so you want to work?
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?
what are the thump rules of taking BOQ of building construction?nallaPERUMAL 9003858728.
Is there any symbolic or cultural significance behind the structure of the buildings you are observing?
What is the more accurate formula to convert wet concrete to dry aggregate instead of the 54% method?
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?
what is the difference between R/3 Internet sales and CRM Internet sales?can a plant be assigned to multiple company codes?can a sales org. be assigned?
