Connect to DataBase use C Script

One of the experts (Salma) did an excellent web page. But now is not available anymore
Anyway, here is an example of how to do that in C

[code]
__object *cn;
__object *rs;
cn = __object_create("ADODB.Connection");
rs = __object_create("ADODB.Recordset");
cn->ConnectionString = "Provider=MSDASQL;DSN=SampleDSN;UID=;PWD=;
cn->Open();
rs=cn->Execute("select TagValue from WINCC_DATA where ID = 1");
if(rs->Fields(0)!=NULL)// It means there are values there
{ //actios to do
}
else
//
rs->Close();
cn->Close();
__object_delete(rs);
__object_delete(cn);
[/code]