Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is the format of a SQLConnection connection string?

Status
Not open for further replies.

xarzu

IS-IT--Management
Jan 16, 2012
19
0
1
US


What is the format of a SQLConnection connection string that is passed in the constructor method? I have run a search engine search online and all I could find so far is examples like:
Code:
 "Data Source=(local);Initial Catalog=AdventureWorks; Integrated Security=SSPI;";
and
Code:
 "User Id=sa;Server=localhost;Initial Catalog=Test;"

The examples raises questions. Since the SQL Server Management Studio (SSMS) program offers a different set of fields during start up in order to connect to a database, I have to ask how does "Server type, "Server name", "Authentication", "User name" and "Password". Also, is "Catalog" another name for a database table?


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top