What is the format of a SQLConnection connection string?
-
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: "Data Source=(local);Initial Catalog=AdventureWorks; Integrated Security=SSPI;"; "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?
-
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: "Data Source=(local);Initial Catalog=AdventureWorks; Integrated Security=SSPI;"; "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?
.NET Framework Data Provider for SQL Server Connection Strings - ConnectionStrings.com[^] The options used to be listed on the
ConnectionStringdocumentation, but that table seems to be missing at the moment: SqlConnection.ConnectionString Property (System.Data.SqlClient) | Microsoft Docs[^] There's an active bug report[^] for the missing table. If I'm reading the updates correctly, it looks like Microsoft are planning to fix it some time this month.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
