This paper introduces the ADO database programming technology used in the design of high-voltage frequency converter monitoring software to achieve functions such as recording operating parameters. Code examples are provided, and a detailed explanation is given of how to dynamically create databases and tables using ADO objects in a VB program. These methods are highly practical in developing VB database applications and can improve database flexibility.
Keywords: ADO, ADOX, high-voltage frequency converter, database programming
Application of PrOgramming Technology of ADO Database in Supervise Control Software of High Voltage Inverter
Abstract： This paper introduces the programming technology of ADO atabase which is used in the supervise-control software of high voltage inverter in order to realize the functions． such as recording the running parameters etc. The program codes are presented and the methods of ADO object which is used to create database and data table dynamically in VB program are illuminated in detail． These methods are practically used for the development of VB database application program. which can greatly enhance the flexibility of database program．
Keywords： ADO． ADOX. High Voltage Inverter． Database Program
The high-voltage frequency converter monitoring software developed based on VB6.0 needs to record operating parameters, fault information, function setting parameters, basic parameters of the high-voltage frequency converter, rated parameters, and motor parameters during the monitoring process. Additionally, it needs to display waveforms, store them, and allow for waveform playback. These functions can be implemented using ADO database programming technology. ADO is a simple and easy-to-use data interface independent of development tools and languages; accessing the database through ADO object programming provides users with great convenience.
1. Introduction to ADO and ADO×
VB provides several methods for accessing databases: Data Access Objects (DAO), Remote Data Objects (RDO), and ActiveX Data Objects (ADO). ADO is a successor to DAO/RDO, extending the object model used by DAO and RDO. It is based on OLE DB technology, and therefore provides a unified data access interface through its internal properties and methods. It is an easy-to-use application programming interface with simpler and more flexible operation.
When developing database applications using ADO, you need to reference the object library "Microsoft ActiveX Database 2.5 Library" (ADO for short), which is a commonly used object library by VB database developers. If you want to dynamically create databases and tables during program execution, you also need to reference the object library "Microsoft ADO Ext. 2.8 For DDL Security" (ADOX for short), whose library file name is msadox.dll. ADOX is an extension of the ADO object and programming model, extending ADO to include creation, modification, and deletion schema objects. It also includes security objects for maintaining users and groups, as well as granting and revoking permissions for objects.
In VB, there are generally two ways to perform operations on ADO: one is through non-programming access using the ADO Data control; the other is to use ADO objects programmatically to access various types of databases.
For details, please click: Application of ADO Database Programming Technology in High Voltage Frequency Converter Monitoring Software
