2008年11月6日星期四

SQL Server 2008 连接字符串(ODBC)

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;

没有评论: