What does connection string consists of ?

Question Posted / mathur

4 Answers
11126 Views
Digital GlobalSoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What does connection string consists of ?..

Answer / sachin gupta

it consist
1. data source(Server)
2. database(Initial Catalog)
3. user name(Uid)
4. password(Pwd)
5. Integrated Security
6. Provider

Is This Answer Correct ?

13 Yes

0 No

What does connection string consists of ?..

Answer / ansu kamar

it consist of
data source
database
user name
password

Is This Answer Correct ?

11 Yes

0 No

What does connection string consists of ?..

Answer / hardit singh

sqlconnection con=new sqlconnection
("server=localhost;database=testdb;uid=sa;pwd=sa;");

Is This Answer Correct ?

1 Yes

0 No

What does connection string consists of ?..

Answer / 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

More ADO.NET Interview Questions

What is the difference between data reader and data adapter?

0 Answers

What is disconnected data?

0 Answers

How you will set the datarelation between two columns?

3 Answers

Can datareader hold data from multiple tables?