SQL Server 2005 Connection strings - Connectionstring Examples

		Links
	Handy Links Home C# and VB.NET Comparison RGB TO HEX Conversion Privacy Policy

		Topics
	Networking Programming Sharepoint (MOSS) SSIS

SQL Server 2005 Connection strings

SQL Native Client ODBC Driver Connectionstring Examples

Standard Security:

"Driver={SQL Native Client};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_User_Name;Pwd=Your_Password;"

Trusted connection:

"Driver={SQL Native Client};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;"

SQL Native Client OLE DB Provider Connectionstring Examples

Standard Security:

"Driver={SQL Native Client};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_User_Name;Pwd=Your_Password; "

Trusted connection:

"Driver={SQL Native Client};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes; "

SqlConnection .NET Connectionstring Examples

Standard Security:

"Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;User Id=Your_User_Name;Password=Your_Password;"

Trusted connection:

"Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"

SQL Server as an Instance:

"Server=Your_Server_Name\Your_Instance_Name;Database=Your_Database_Name;Trusted_Connection=True;"

		Great Sites
	Make Money Online Heath and Wealth Articles ITJungles Acne Information Portal