Interested to Buy Any Domain ? << Click Here >> for more details...
What does connection string consists of ?
- 4 Answers
- 11252 Views
- Digital GlobalSoft, I also Faced
- E-Mail Answers
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
Where is adodb dll located?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What is the difference between data grid and data repeater?
What is difference between connected and disconnected architecture in ado.net?
How to load multiple tables into a dataset?
Which is the feature of ado.net?
Which is the best method to get two values from the database?
What is two way data binding android?
What is a dataview?
What is oledb connection?
how can implement dropdownlist in particular of dataset when try to update?
What are the advantage of ado.net?
What is ado.net and its features?
What is ado code?
What are the ado.net objects?
