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
- 5216 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
In informatica by using filter tranformation what is the filter condition to display for the single id empno
what is the role of an architect
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 is the rate of 4000sqft rate, with material tile plumbing all work with plinth? Pl. Send ans. Yourlifeme@indiatimes.com
what is the use of studing architecture
Is DataStage Designer, a thin client or a thick client?
Density of plasterboard 15 mm
Who is responsible for territory? can you please help me in getting the answer for this
How did you decide to go into architecture and what did you do to prepare for this field of work?
what is CEPT and ETSI for telecom?
how much steel is required for 40*35 ft roof slab41/2" thick.what is the spacing from bar to bar.
. A BSC can contain ___________ number of BCF packs.
Why were the Gothic Churches able to have large stain glass windows?
Is there any symbolic or cultural significance behind the structure of the buildings you are observing?
I am Planning to Contruct a floor appartment on my own thro a Contractor . How to estimate the Constrction Cost , to negociate with the Contractor.
