请问WINCC 用C语言操作SQL SERVER 2005 数据库有什么需要注意的么,有没有什么资料可以查看,另外下面是我的代码,可以连上数据库,但是无法操作,希望高手帮忙!
Conn = __object_create("ADODB.Connection");
sprintf(ConnectionString,"Provider='SQLOLEDB.1';Integrated Security='SSPI';Persist Security
Info='False';Initial Catalog='TONYSUN';Data Source='(local)\\WINCC'");
//printf("%s\r\n",ConnectionString);
Conn->Open(ConnectionString);
if (Conn->State==1)
{
rsTemp = __object_create("ADODB.RecordSet");
//sprintf(szQuery,"SELECT * FROM TRENDS_SELECTIONS WHERE PenGroup='%s' AND
COMPUTER='%//s'",Group,computer);
// rsTemp->CursorLocation = adUseClient;
// rsTemp->Open(szQuery, Conn,adOpenKeyset ,adLockOptimistic);
rsTemp->AddNew();
rsTemp->Fields("PenDes cription")->Value=Des cription;
rsTemp->Fields("PenTagName")->Value=Tag_Name;
rsTemp->Fields("PenUnits")->Value=Units;
rsTemp->Fields("PenMax")->Value=Max_Value;
rsTemp->Fields("PenMin")->Value=Min_Value;
rsTemp->Fields("PenObject")->Value=lpszObjectName;
rsTemp->Fields("PenPicture")->Value= lpszPictureName;
rsTemp->Fields("PenGroup")->Value=Group;
rsTemp->Fields("COMPUTER")->Value=computer;
rsTemp->Update;
Conn->Close;
}