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
- 5135 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
how to know low voltage and high voltage ranges for electrical machinery ?
Means of interrupt in cpu operations?
Why do u want to join vastu vihar
what is the rate of 4000sqft rate, with material tile plumbing all work with plinth? Pl. Send ans. Yourlifeme@indiatimes.com
Who is responsible for territory? can you please help me in getting the answer for this
what are the differences of software life cycle models
. A BSC can contain ___________ number of BCF packs.
what so you want to work?
Who can give me Stracher Design for my plan For Coloum Position. Please call me 9921761702
How CPU handle an interrupt operations?
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?
Is this house typical of the houses of this community? What makes it typical or atypical?
what cut of marks in cgl2010 tier2
what type of mapping is most used in maya production house?
