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 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


Please Help Members By Posting Answers For Below Questions

details about telephone wiring

2130


How did you decide to go into architecture and what did you do to prepare for this field of work?

2033


Means of interrupt in cpu operations?

1223


Is this house typical of the houses of this community? What makes it typical or atypical?

2466


rate for 5" thk rcc slab using rebarring in pune

1490


In informatica by using filter tranformation what is the filter condition to display for the single id empno

2301


what is the difference between R/3 Internet sales and CRM Internet sales?can a plant be assigned to multiple company codes?can a sales org. be assigned?

2197


How is BP in CRM synchronised with R/3? What r all the steps involved?can we do the partner determination based on SALES AREAS?

2093


How CPU handle an interrupt operations?

1259


Why do u want to join vastu vihar

1290


what is the role of an architect

2281


what is the KVAR and how to measure it ?

2477


What was your favorite pictures in the architecture of the Middle Ages? Why?

2328


What is the name of the first type of building used in Christian Churches?

3622


i am looking for Final year Architecture Designer or any home based project worker in chennai. contact 9500092822

3646