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
How does entity framework work?
What is the use of data grid?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What is dataset and datatable in ado.net?
Is it possible to edit data in Repeater control?
What are the pre-requisites for connection pooling?
Describe the command object and its method.
What is ole word?
What are three methods for displaying data in a syncfusion datagrid
What are the different layers of ado.net?
What are the different ado.net namespaces?
What is the difference between dataset and datatable?
How to Read, Add, Update and Delete record in Entity Framework ?
What is sqldatareader in ado.net?
What is connected architecture in ado.net?