What does connection string consists of ?
Answers were Sorted based on User's Feedback
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 |
Answer / ansu kamar
it consist of
data source
database
user name
password
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / hardit singh
sqlconnection con=new sqlconnection
("server=localhost;database=testdb;uid=sa;pwd=sa;");
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
Why edit is not possible in repeater?
How does entity framework work?
what are types of Dataset ?
How to get the new oledb connection of oracle in database programming?
Why do we need ado.net?
Where do you store connection string ?
How can we check that some changes have been made to dataset since it was loaded?
Difference between function and trigger?
What is the key feature of ADO.NET compared to ADO ?
What are relation objects in dataset and how & where to use them?
What is the difference in record set and dataset?
What providers do you use to connect to oracle database ?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)