What does connection string consists of ?

Answer Posted / m.chandran

Connection String for SQL Server consist of:
1.Data Source or server= “.”; or "Localhost" or "127.0.0.1" or "serverNameinstanceName" or "N/W SQL server IP Address" Server instance.
2.Initial Catalog or database = “DATABASE_NAME”;
Either3.Uid=”UserID for SQL server” and Password= “Password for SQL server”;
ORIntegrated Security=”True”; Use Windows security

optional
5.Provider Name =”System.Data.SqlClient”;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

768


What is ado recordset?

686


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

744


Define different execute methods of ADO.NET command object ?

755


What are the different methods available under the sqlcommand class to access the data?

792


What is serialization and de-serialization in .net?

697


What connected data?

691


Explain ado.net features?

780


What is data control techniques?

694


How to Read, Add, Update and Delete record in Entity Framework ?

783


How to connect and retrieve data from database using dataset

740


What is ado.net object model?

714


What are the objects of ado.net?

768


What is ado circle?

877


What is execute scalar in ado.net?

702