发布于 2014-08-14 11:09:26
5楼
可以使用直接连接方式,帮助文档中有现成的例子。
main()
{
int rc;
dbConnection conn;
dbRecordset rs;
anytype fld;
rc = dbOpenConnection ("DRIVER=Microsoft Access Driver (*.mdb);DBQ=TEST.MDB;DefaultDir=C:\\test\\jetdb;UID=;PWD=;", conn);
if (!rc)
{
rc = dbOpenRecordset (conn, "SELECT * FROM PERS", rs);
// The data subset is opened
if (!rc)
{
while (!rc && !dbEOF (rs))
// as long as the file end is not reached
{
rc = dbGetField (rs, 0, fld);
//reads current column
if (!rc)
DebugN("Field 1: " , fld);
rc = dbGetField (rs, 1, fld);
if (!rc)
DebugN("Field 2: " , fld);
rc = dbMoveNext (rs); //to the next record
}
dbCloseRecordset (rs); //closes subset
}
dbCloseConnection (conn); //closes connection
}
}
上面的代码摘自PVSS V3.11 SP1帮助。