SQL Server 2008 连接字符串（SQL Native Client OLE DB Provider）

SQL Server 2008
SQL Native Client OLE DB Provider
标准登录：
Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

可信连接：
Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes;

网络传递数据加密：
Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes;Encrypt=yes;

附加数据库文件到SQLExpress
Provider=SQLNCLI10;Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf; Database=dbname; Trusted_Connection=Yes;

附加数据文件夹中的数据库文件到本地SQLExpress
Provider=SQLNCLI10;Server=.\SQLExpress;AttachDbFilename=DataDirectorymydbfile.mdf; Database=dbname;Trusted_Connection=Yes;