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
- 5036 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
Who is responsible for territory? can you please help me in getting the answer for this
what is the difference between R/3 Number range and CRM range?
rate for 5" thk rcc slab using rebarring in pune
why you want to become artictecture
how to measure 4mm,6mm,12mm,18mm plywood into a cubic meter and how many layers in a cubic meter
difference between action and collaboration in object oriented designing and modeling
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?
details about telephone wiring
what are the thump rules of taking BOQ of building construction?nallaPERUMAL 9003858728.
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.
Why were the Gothic Churches able to have large stain glass windows?
Means of interrupt in cpu operations?
how much steel required for 1 sq area for swimmin pool construcion
What is meant by fetch and execute cycle in cpu operations
I have 14 diffrent shape gogles.how can I use this in architructure design??
