_ConnectionPtr cnn=NULL;
cnn.CreateInstance(_uuidof(Connection));
cnn->Open("Driver=SQLServer;Database=Student;Server=127.0.0.1;","","",adCmdUnspecified); CString sSQL,Sno,Sname;
Sname="张三";
sSQL.Format("UPDATE FROM Student1 SET Sname='%s' WHERE Sno=2",Sname);
cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
cnn->Close();
cnn.CreateInstance(_uuidof(Connection));
cnn->Open("Driver=SQLServer;Database=Student;Server=127.0.0.1;","","",adCmdUnspecified); CString sSQL,Sno,Sname;
Sname="张三";
sSQL.Format("UPDATE FROM Student1 SET Sname='%s' WHERE Sno=2",Sname);
cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
cnn->Close();
asp.net 交流群:106041515
java 交流群: 106041212
sql server 交流群:33968565欢迎大家加入讨论
加上信用连接试试:Trusted_Connection=True;
http://www.connectionstrings.com/sql-server-2008#p1
(KERNEL32.DLL)
("Driver=SQLServer;Database=Student;Server=127.0.0.1;","sa","",adCmdUnspecified);