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
- 4341 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 did you choose Architecture as your major?
How to construct Pile foundation?
How to represent -67 in Hexadecimal?
What is the OLAP Position in the folloeing two categories wehen we access data warehouse data from operational environment 1) indirect access of datawarehouse data 2) indirect use of datawarehouse data
What personal quality is important to be an architect?
FROM THE WHICH FONT USED MEANS SMALL SIZE TEXT IN A0 SIZE PAPER, NEED TO SITE EXECUTION PURPOSE DRAWING DRAWING NEED TO TAKE PRINT IN A3 SIZE ALSO MEANS WHICH FONT USED MEANS POSSIBLE TO READ BOTH PRINT
what is an IDOC?Why do we use them? how do we process them? what is meant by RFC in middleware?
How are European, Asian and US perceptions of architecture different?
explain transmission parameter baud rate
I am building a house in Iowa by the strict requirements and dimensionality of Sthapatya-ved. As you probably know, these dimensions are specific to certain harmonic structures generated by the architectural style and my astologic chart. The outer walls will be approximately 10.5 inches thick. I would like to use some sort of straw/clay mixture, but I also live in a very cold climate. It is not unusual to have -10 degree temperatures for several weeks on end. I have friends who built with rammed earth and their environment is miserable during winter, always fighting the fly-wheeling of energy in the earth structure. Can you shed any light on the true insulation value of a straw clay mixture in this climate.
rate for 5" thk rcc slab using rebarring in pune
Which of the following sentence is not correct
Interior Design 
