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
- 5108 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
give me details about EPBX system
What is the more accurate formula to convert wet concrete to dry aggregate instead of the 54% method?
types of load
What is the name of the first type of building used in Christian Churches?
Structural wall & slab : Binding wire fixing is alternatively spacing is correct or wrong?. binding wire fixing is all spacing is must or not?
Why were the Gothic Churches able to have large stain glass windows?
how many steel rod of the cilling 10'x10'
what is hvac?
what is the use of studing architecture
how much steel is required for 40*35 ft roof slab41/2" thick.what is the spacing from bar to bar.
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
why you want to become artictecture
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 feature is unique to the Hagia Sophia?
ssc cgl 2010 may tax assistant ki cut of kya hogi
