The remote data collection system based on SOL Server database technology was developed by Visual C++and SQL Server database technology together.The Client/Server mode was adopted.The system adopted the database searc...The remote data collection system based on SOL Server database technology was developed by Visual C++and SQL Server database technology together.The Client/Server mode was adopted.The system adopted the database search technologi- cal-ADO to work out the communication procedure of the server.And the old data of corresponding memory units were upgraded by the new data which gathered from PLC through serial port real time in the database.The Client utilizes the network technology and database technology through queries procedure to access the data information in the database.Thus a large number of relevant data that the production line operated were obtained.The goal of understanding operation conditions of product line was achieved through analysis of these data.This system has been debugged by the experiment successfully.展开更多
在建立Web数据库站点的应用中,将ASP技术与SQL Server数据库相结合,使数据库管理更加的方便和安全。因此如何利用ASP访问SQL Server 2000数据库成为了Web数据库站点开发的关键。首先介绍了ASP访问SQLServer 2000数据库所用到的ADO组件,...在建立Web数据库站点的应用中,将ASP技术与SQL Server数据库相结合,使数据库管理更加的方便和安全。因此如何利用ASP访问SQL Server 2000数据库成为了Web数据库站点开发的关键。首先介绍了ASP访问SQLServer 2000数据库所用到的ADO组件,接着阐述了ASP与SQL Server 2000数据库建立连接的4个主要步骤。展开更多
基于SQL Server代理(SQL Server Agent),提出一种实用于地区电网自动电压无功控制(AVC)系统的备份方案,根据地区电网数据库的特点进行分类备份,通过定期清除日志和过期数据文件的方式,有效地解决了地区电网AVC系统日志溢出问题,大大提...基于SQL Server代理(SQL Server Agent),提出一种实用于地区电网自动电压无功控制(AVC)系统的备份方案,根据地区电网数据库的特点进行分类备份,通过定期清除日志和过期数据文件的方式,有效地解决了地区电网AVC系统日志溢出问题,大大提高数据备份效率,基于FTP协议实现地区电网AVC子站与主站系统之间的备份异地传输,改善了恢复点目标(RPO)和恢复时间目标(RTO),提高了整个AVC系统的容灾能力。基于SQL Server Agent编写了应用程序,在实际地区电网AVC系统的应用证明,该备份方式具有操作简单、成本低的特点,备份效果良好,满足地区电网AVC系统对数据备份与恢复的要求。展开更多
ActiveX数据对象(Active Data Object,简称ADO)是由微软公司推出的以ActiveX技术为基础的一种数据访问方法。它具有速度快、使用方便、内存占用少等特点。该文以一个小型的图书管理系统为例,介绍在VB6.0中如何使用ADO数据控件结合SQL语...ActiveX数据对象(Active Data Object,简称ADO)是由微软公司推出的以ActiveX技术为基础的一种数据访问方法。它具有速度快、使用方便、内存占用少等特点。该文以一个小型的图书管理系统为例,介绍在VB6.0中如何使用ADO数据控件结合SQL语句实现数据库应用程序的开发。展开更多
文摘The remote data collection system based on SOL Server database technology was developed by Visual C++and SQL Server database technology together.The Client/Server mode was adopted.The system adopted the database search technologi- cal-ADO to work out the communication procedure of the server.And the old data of corresponding memory units were upgraded by the new data which gathered from PLC through serial port real time in the database.The Client utilizes the network technology and database technology through queries procedure to access the data information in the database.Thus a large number of relevant data that the production line operated were obtained.The goal of understanding operation conditions of product line was achieved through analysis of these data.This system has been debugged by the experiment successfully.
文摘在建立Web数据库站点的应用中,将ASP技术与SQL Server数据库相结合,使数据库管理更加的方便和安全。因此如何利用ASP访问SQL Server 2000数据库成为了Web数据库站点开发的关键。首先介绍了ASP访问SQLServer 2000数据库所用到的ADO组件,接着阐述了ASP与SQL Server 2000数据库建立连接的4个主要步骤。
文摘基于SQL Server代理(SQL Server Agent),提出一种实用于地区电网自动电压无功控制(AVC)系统的备份方案,根据地区电网数据库的特点进行分类备份,通过定期清除日志和过期数据文件的方式,有效地解决了地区电网AVC系统日志溢出问题,大大提高数据备份效率,基于FTP协议实现地区电网AVC子站与主站系统之间的备份异地传输,改善了恢复点目标(RPO)和恢复时间目标(RTO),提高了整个AVC系统的容灾能力。基于SQL Server Agent编写了应用程序,在实际地区电网AVC系统的应用证明,该备份方式具有操作简单、成本低的特点,备份效果良好,满足地区电网AVC系统对数据备份与恢复的要求。
