以windows身份验证方式验证的连接串怎么写
我想连接.\SQLEXPRESS 本地实例数据库,但对我这样写
select * from T_CQFFSMS_Project_Region_Mst IN ODBC[ODBC;Driver=SQL Server;Server=.\SQLEXPRESS ;Uid=sa;Pwd=sa;database=CQFFSMS]
错了
[解决办法]
SELECT *
FROM Orders IN ODBC[ODBC;Driver=SQL Server;UID=sa;PWD=0;Server=.;DataBase=Northwind];
[解决办法]
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=数据库;Data Source=server名
