Question

labwindows cvi如何与SQL数据库连接

Answer 1

1.在ODBC中配置数据源
2.ConnectHandle=DBConnect ("DSN=CVILocal;UID=sa;PWD=123");
ActivateHandle= DBActivateSQL (ConnectHandle, "select * from 标志位表");
while(DBFetchNext(ActivateHandle)==DB_SUCCESS)
{
DBGetColVariant (ActivateHandle, 2, &TempInt);
CA_VariantConvertToType (&TempInt, CAVT_INT, &StartMarkInt);
}
DBDeactivateSQL (ActivateHandle);
DBDisconnect (ConnectHandle);