Which parameters define the database server in the connection string?

Posted by Ddd on 3/23/2011 | Category: ADO.NET Interview questions | Views: 5410 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

These are the parameters which define the database server through its name or IP address. We can use any one of them.
1) Data Source
2) server
3) addr
4) address
5) network address

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What are the disadvantages of AJAX?

Next > : What is Code Instrumentation?

Comments or Responses

Posted by: Muralik.it on: 6/7/2011 | Points: 10

<add key="ConnectionString"
value="serverabc;
database=test;
uid=operator;pwd=sa"/>

so in connection string, 'value' property defines the servername and 'database' property defines the name of the database

More Interview Questions by Ddd

What is Code Instrumentation?
Difference between Globalization and Localization ?
Can you cache a web page on the basis of stylesheets?
Where does caching of a UserControl occur?
How can you prevent data to be removed from Cache when memory becomes ...
Which of these objects must be there when storing data in a disconnect ...
Can we save ViewState on the server side?
What is RedirectPermanent?

Latest Interview Questions

Write the difference between Group box control and Panel control?
What is the difference between "Convert" class and "Par ...
Write the difference between Stack and Heap?
What is "Content Type" for a FileUpload control?
What is "Has File" property for a FileUpload control?
Explain two different scenarios where the Static Constructors can be u ...
Why is it not a good programming practice to use empty Destructors ?
Can we force Garbage Collector to run ?
More ...