贴一段C脚本数据库访问的例子:
__object *cn, *rs;
int i,fields=10;
cn=__object_create("ADODB.Connection");
rs=__object_create("ADODB.RecordSet");
// Connect
cn->Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=Northwind;Data Source=(local)\\WinCC");
if (cn->State == 0) printf ("DB Connect failed\n");
else
{
rs->Open("Select * FROM Products",cn,1);
rs->MoveFirst;
while(!rs->eof) {
for(i=0;i
Fields(i)->Value); printf (" "); }
printf("\r\n");
rs->MoveNext;
}
rs->Save("C:\\my.xml",1);
rs->Close;
cn->Close;
管理员注:本帖已被纳入此次探讨发帖整理WinCC脚本应用,请点此详阅。