Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.



The main issue is suppose i have two databases and when user wants data for last 10 years data,it ..

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

Post New Answer

More Architecture Design AllOther Interview Questions

how much steel is required for 40*35 ft roof slab41/2" thick.what is the spacing from bar to bar.

0 Answers   Asian Paints,


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

1 Answers  


How to calculate stabilizer for a machine

0 Answers  


data retrival is faster when we use PPI in a table. But my question is is PPI affects the Multiload performence my any chance?

0 Answers  


Do you have any ideas on how we could build a single vault and use lower embodied energy products?

1 Answers  


As an architect, how do you blend contemplory materials used in construction with the natural?

1 Answers  


give maaterial requesion for 6x3x1 Mcube machnine foundation

1 Answers   MAHINDRA,


what was the most complex thing you worked on?

1 Answers  


what is the use of studing architecture

0 Answers  


. A BSC can contain ___________ number of BCF packs.

0 Answers   Nokia,


What feature is unique to the Hagia Sophia?

0 Answers  


Tell me about a time when you had a project to complete with very little background materials?

0 Answers  


Categories
  • Interior Design Interview Questions Interior Design (21)
  • Architecture Design AllOther Interview Questions Architecture Design AllOther (186)