SQL Server connection strings

最新推荐文章于 2021-11-08 17:13:09 发布

weixin_30666943

最新推荐文章于 2021-11-08 17:13:09 发布

阅读量172

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/hyouhaku/archive/2005/04/25/144975.html

版权

SQL ODBC connection strings

Standard Security:
"Driver={SQL Server};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;"

Trusted connection:
"Driver={SQL Server};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;"

SQL OLE DB connection strings

Standard Security:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;User Id=Your_Username;Password=Your_Password;"

Trusted connection:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"

SQL OleDbConnection .NET strings

SQL SqlConnection .NET strings

Standard Security:
1. "Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;User Id=Your_Username;Password=Your_Password;"
2. "Server=Your_Server_Name;Database=Your_Database_Name;User ID=Your_Username;Password=Your_Password;Trusted_Connection=False"

Trusted connection:
1. "Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"
2. "Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=True;"

转载于:https://www.cnblogs.com/hyouhaku/archive/2005/04/25/144975.html