读书人

VC6.0 ADO连接sql server2000时连接不

发布时间: 2013-01-22 10:23:54 作者: rapoo

VC6.0 ADO连接sql server2000时连接不上,不存在或拒绝访问
VC6.0 win32下 ADO连接sql server2000时连接不上,不存在或拒绝访问
服务器是自己电脑上的,服务器:SYS-EA878A07116\WANG
用户数据源名称:datasql
_bstr_t strConnect = "Provider = SQLOLEDB.1;Integrated Security = SSPI;Persist Security Info = fasle;Initial Catalog = datasql;Server = SYS-EA878A07116\WANG;Database =pubs;uid =sa;pwd =1234";
m_pConnection->Open(strConnect,"","",adModeUnknown);
出现sql server不存在或拒绝访问
求各位大神帮帮忙
[解决办法]
本地的看看以前的例子


hr = pConnection->Open("Provider=SQLOLEDB;Data Source=LIYOUHONG\\SQLEXPRESS;Initial Catalog=MyTestConnection;uid=Test1;pwd=123;","","",adModeUnknown);

[解决办法]
m_pConnection->Open("driver={SQL Server};Server=(****);DATABASE=*****;UID=sa;PWD=**","","",adModeUnknown);
我的可以连接

[解决办法]
m_pConnection->Open("driver={SQL Server};Server="服务器";Data Source="数据源”;DATABASE=model;UID=sa;PWD=1234", "", "", adModeUnknown);

读书人网 >VC/MFC

热点推荐