The main issue is suppose i have two databases and when user wants data f

Advertise your Business Here

Refer this Site

Login | Sign Up


	Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff HERE

Categories >> Architecture Design >> Architecture Design AllOther

Architecture Design AllOther Interview Questions

Question

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.

Question Submitted By :: Venkat

I also faced this Question!!

Rank

Answer Posted By

Re: 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
# 1

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

0 No

Vamshi Krishna

Question	Asked @	Answers
Other Architecture Design AllOther Interview Questions


Do you have any ideas on how we could build a single vault and use lower embodied energy products?		1
what different types of wood is there?	CIL	1
Iam studying architecture in India. I have an interest in vernacular arcjitecture. I want to specialize in that, so what are the ways for that, after graduation?		1
What are the properties of anthill/termites soil and its use in construction?		1
Is there any information about building environmentally in the retarded South. (SC)?		1
What methods and materials would you suggests for the Mediterranean environment?		1
I want to build a home by digging a large hole and cementing the floor and all walls, then making a slanted roof for water runoff, with windows on the south side. How will I keep a steady temperature of 68 degrees with no moisture?		1
if earth building is diffused around the world in countries who need help for resources such as the ones earth ship can give?		1
Iam an architecture student doing research about the vernacular architecture of the indian temples as well as that of domestic japan, please send me information as soon as possible.		1
I am in the process of designing a small traditional Japanese house for myself. I am trying to use as many natural materials as possible. I believe one of the traditional methods was the use of clay in the exterior walls and finish. I would like to stay away from treated plywood if I can. Could you offer some suggestions?		1
what is speciality of Gothic Architecture?		1
As an architect, how do you blend contemplory materials used in construction with the natural?		1
What is the difference between (with what type of material they are made of)RAM cells and Cache memory cells	MIT	2
Green building has many positive effects on the environment. What are the most significant environmental benefits?		1
We would like to experiment with some kind of eco-building here in this 'Tropical rain forest'. What kind of eco- building techniques do you suggest that we look into?		1
what are some disadvantages are for using using cement in building a home?	Ambuja	1
What do we mean by domestic architecture artifacts?		1
Why was it important to have large stain glass in the Gothic Cathedrals? How did these churches help the Catholic Church meet it's goals?		1
What's the best strategy to retroactively remodel to be greener?		1
whta is meant by lintel?		1

For more Architecture Design AllOther Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com