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
- 5219 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 kind of matirials would you use for building a house in earthquake land?
What personal quality is important to be an architect?
Dear Sir, I got 90kilowat and 3 face for my house.So which cable is the best for my home main line. Thanks Bashir Ahmed e-mail: bcon.ba.bd@gmail.com
I have 14 diffrent shape gogles.how can I use this in architructure design??
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.
what advice do you have for Architectural Draughtsmanship student who wish to became architects?
Why was it important to have large stain glass in the Gothic Cathedrals? How did these churches help the Catholic Church meet it's goals?
How are European, Asian and US perceptions of architecture different?
Green building has many positive effects on the environment. What are the most significant environmental benefits?
what is speciality of Gothic Architecture?
What feature is unique to the Hagia Sophia?
what is the standard bricks size, and which tools required for mason work
Interior Design 
