Docstoc

SQL Server connection strings

Document Sample
SQL Server connection strings Powered By Docstoc
					  For QTP Documents and Scripts visit: www.gcreddy.com


      SQL Server connection strings
SQL ODBC connection strings

Standard Security:< br>
"Driver={SQLServer};Server=Your_Server_Name;Database=Your_Da
tabase_Name;Uid=Your_Username;Pwd=Your_Password;"

Trusted connection:< br>
"Driver={SQLServer};Server=Your_Server_Name;Database=Your_Da
tabase_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_Passw
ord;"

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_Passw
ord;"

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_Passw
ord;" < br>2.
"Server=Your_Server_Name;Database=Your_Database_Name;UserID
=Your_Username;Password=Your_Password;Trusted_Connection=Fals


 For Manual Testing Documents visit: www.gcreddy.net        1
     For QTP Documents and Scripts visit: www.gcreddy.com

e"

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;Trust
ed_Connection=True;"




 For Manual Testing Documents visit: www.gcreddy.net        2

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:160
posted:3/14/2010
language:English
pages:2
Description: SQL Server connection strings for connecting SQL Server databases