2

I've been hunting for this information for years now but I don't seem to be able to find it:

Is there any documentation available on learn.microsoft.com providing a table with all valid connection string parameters, their valid argument values, their default values and their implications, for SQL Server and LocalDB?

All I find are some tutorials and example pages, but no thorough reference page.

Paul White
  • 94,921
  • 30
  • 437
  • 687
AxD
  • 133
  • 5

1 Answers1

6

Connection string keywords for Microsoft-supplied SQL Server drivers vary by API. The documentation is included with the API-specific driver documentation.

Below are links to the official Microsoft documentation connection string keyword pages for some commonly used drivers. I did not include older and legacy drivers as those should not generally be used for new development.

System.Data.SqlClient (.NET Framework)

Microsoft.Data.SqlClient (.NET Core)

Microsoft JDBC Driver

Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)

ODBC Driver for SQL Server (ODBC Driver 17 for SQL Server)

Dan Guzman
  • 28,989
  • 2
  • 46
  • 71