[数据库连接字符串] SQL Server 连接字符串

来源：互联网发布：seo专员岗位职责编辑：程序博客网时间：2024/05/28 17:05

ODBC 标准连接

Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

受信的连接

Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes;

指定帐号和密码

oConn.Properties("Prompt") = adPromptAlways

Driver={SQL Server};Server=myServerAddress;Database=myDataBase;

OLE DB, OleDbConnection (.NET) 标准连接

Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

受信的连接

Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

使用serverName/instanceName作为数据源可以指定SQL Server实例。连接到一个SQL Server的实例指定服务器实例的表达式和其他SQL Server的连接字符串相同。

Provider=sqloledb;Data Source=myServerName/theInstanceName;Initial Catalog=myDataBase;Integrated Security=SSPI;

指定帐户和密码

oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways

Data Source=myServerAddress;Initial Catalog=myDataBase;

使用IP地址的连接

Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

SqlConnection (.NET) 标准连接

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Standard Security alternative syntax

Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;

受信任的连接

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Trusted Connection alternative syntax

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

连接到SQL Server实例指定服务器实例的表达式和其他SQL Server的连接字符串相同。

Server=myServerName/theInstanceName;Database=myDataBase;Trusted_Connection=True;

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain/myUsername;Password=myPassword;

仅能用于CE设备。带有IP地址的连接

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

指定包的大小

Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;Packet Size=4096;

默认的包大小为8192字节。 Data Shape MS Data Shape

Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;