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

How does entity framework work?

675


What is the use of data grid?

726


How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

806


What is dataset and datatable in ado.net?

739


Is it possible to edit data in Repeater control?

718


What are the pre-requisites for connection pooling?

753


Describe the command object and its method.

768


What is ole word?

745


What are three methods for displaying data in a syncfusion datagrid

845


What are the different layers of ado.net?

773


What are the different ado.net namespaces?

855


What is the difference between dataset and datatable?

743


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

807


What is sqldatareader in ado.net?

703


What is connected architecture in ado.net?

720