SQL ODBC connection strings

Standard Security:< br> “Driver={SQLServer}; Server=Your_Server_Name; Database=Your_Database_Name; Uid=Your_Username; Pwd=Your_Password;”

Trusted connection:< br> “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;” < br>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;”

Advertisements