SQL数据库连接字符串大全.doc

SQL Server ODBC Standard Security: Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd; Trusted connection: Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes; PRompt for username and passWord: oConn.Properties(Prompt) = adPromptAlways oConn.Open Driver={SQL Server};Server=Aron1;DataBase=pubs; OLE DB, OleDbConnection (.NET) Standard Security: Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd; Trusted Connection: Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI; (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000) Prompt for username and password: oConn.Provider = sqloledb oConn.Properties(Prompt) = adPromptAlways oConn.Open Data Source=Aron1;Initial Catalog=pubs; Connect via an ip address: Provider=sqloledb;Data Source=00,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd; (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default)) SqlConnection (.NET) Standard Security: Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd; - or - Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False (both connection strings produces the same result) Trusted Connection: Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI; - or - Server=Aron1;Database=pubs;Trusted_Connection=True; (both connection strings produces the same result) (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000) Connect via an IP address: Data Source=00,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd; (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default)) Declare the SqlConnection: C#: using System.Data.S