发布于 2005-01-15 09:28:38
0楼
V5不支持VBS,只能用C写代码。
__object *cn, *rs;
cn = __object_create("ADODB.Connection");
rs = __object_create("ADODB.RecordSet");
if(NULL==cn)
printf("Create Connection Failed\r\n");
else printf("Create Connection Successful\r\n");
cn->Open("DSN=WinCCs cripting");//这里的DSN用你的SQL2000的
if (cn->State==0)
printf("Connection Failed\r\n");
else {
printf("Connection Successful\r\n");
rs->Open("SELECT * FROM Product", cn,1);
printf("No Of Records: %i \r\n",rs->RecordCount);
rs->MoveFirst==0;
while(!rs->eof) {
printf(rs->Fields(0));
printf(" ");
printf(rs->Fields(1));
printf("\r\n");
rs->MoveNext;
}
}
rs->Close;
只能描述个大概,自己动手吧。
无论成与败,无论甜与苦,我还是我。