2018年08月07日

SQL Server Connection Strings


SQL Server Connection Strings

Standard Security:

"Driver={SQLServer};Server=Your_Server_Name; Database=Your_Database_Name;Uid=Your_Username; Pwd=Your_Password;"

Trusted connection:

"Driver={SQLServer};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; UserId=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
Standard Security:

"Provider=SQLOLEDB;Data Source=Your_Server_Name; Initial Catalog= Your_Database_Name; UserId=Your_Username; Password=Your_Password;"

Trusted connection:

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

SQL SqlConnection .NET strings
Standard Security:

1."Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name; UserId=Your_Username; Password=Your_Password;"

2."Server=Your_Server_Name;Database=Your_Database_Name; UserID=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;"

posted by a23 at 15:25| Comment(0) | MS SQL Server
この記事へのコメント
コメントを書く
お名前:

メールアドレス:

ホームページアドレス:

コメント: