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
- 5039 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 |
why you want to become artictecture
Discuss the concept of system transition strategy.
the desirable depth of a wardrobe fore hanging cloths
How did you decide to go into architecture and what did you do to prepare for this field of work?
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.
tell about different type of wood available in india and there uses?
what is the KVAR and how to measure it ?
types of load
how to know low voltage and high voltage ranges for electrical machinery ?
Why were the Gothic Churches able to have large stain glass windows?
what cut of marks in cgl2010 tier2
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.
Interior Design 
