VC6用 MFC ado连接远程sql server2008 ,windows身份验证的连接字符是什么?
迷之程序员 2017-07-21 11:35:53 VC6用 MFC ado连接远程sql server2008 ,用windows身份验证,连接本地的是可以的:
//m_pConnection->Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TEST2;Data Source=DESKTOP-COB5OT8\\SQLEXPRESS","","",adModeUnknown);
但是连接服务器上的数据库
我用
m_pConnection->Open("driver={SQL Server};server=ip;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=contractdb;Data Source=WINDOWS-TCPNWT3\\SQLEXPRESS","","",adModeUnknown);
就连接不上。因为用用windows身份验证不需要输入用户名和密码吗