Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5055 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
how much steel bar required for 1 sqm area
The telecommunications offered by the GSM PLMN may be divided into three main groups.what is it?
what type of mapping is most used in maya production house?
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
how to know low voltage and high voltage ranges for electrical machinery ?
what advice do you have for Architectural Draughtsmanship student who wish to became architects?
Density of plasterboard 15 mm
difference between action and collaboration in object oriented designing and modeling
Structural wall & slab : Binding wire fixing is alternatively spacing is correct or wrong?. binding wire fixing is all spacing is must or not?
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 to calculate stabilizer for a machine
How CPU handle an interrupt operations?
what is hvac?
What personal quality is important to be an architect?
. A BSC can contain ___________ number of BCF packs.
