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.
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 |
1. What are the three services offered by GSM? Explain each of them briefly.
What is difference between Stracture of DBMS & Architecture of DBMS
why you want to become artictecture
Have you heard about any earth bag project implemented in Poalnd ? I have some doubts if our climate is suitable for this kind of system.
give maaterial requesion for 6x3x1 Mcube machnine foundation
Why did the wall of Romanesque Churches have to be so thick?
What is the difference between (with what type of material they are made of)RAM cells and Cache memory cells
Who can give me Stracher Design for my plan For Coloum Position. Please call me 9921761702
Is there any structure that you've been in that it was difficult to leave?
What is meant by OSI model?
Iam commiting an argument that postmodern architecture is copied. In particular I am researching into the structure of domes. If you could give me any advise or references to back my argument it would be much appreciated.
How i can calculate material for 1000 sq foot plot.