SQL Server 2008
SQL Native Client ODBC Driver
标准登录:
Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
可信连接:
Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;
网络传递数据加密:
Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes;Encrypt=yes;
附加数据库文件到SQLExpress
Driver={SQL Server Native Client 10.0};Server=.\SQLExpress; AttachDbFilename=c:\asd\qwe\mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
附加数据文件夹中的数据库文件到本地SQLExpress
Driver={SQL Server Native Client 10.0};Server=.\SQLExpress;AttachDbFilename=DataDirectorymydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
没有评论:
发表评论