Computer Engineering and Applications ›› 2007, Vol. 43 ›› Issue (16): 186-188.

• 数据库与信息处理 • Previous Articles     Next Articles

Programming approach to arrange user database using SQL and ADO

ZENG Qiang,GONG Yu-chang   

  1. Department of Computer Science and Technology,University of Science and Technology of China,Hefei 230027,China
  • Received:1900-01-01 Revised:1900-01-01 Online:2007-06-01 Published:2007-06-01
  • Contact: ZENG Qiang

基于SQL和ADO的用户数据库自动部署

曾 强,龚育昌   

  1. 中国科学技术大学 计算机系,合肥 230027
  • 通讯作者: 曾 强

Abstract: For arranging user database,it is trivially and complicated for users to use existing installers such as Installsheild or InstallFactory.To resolve the problem above a simple and easy method using SQL and ADO is proposed in this paper.The method is not only universal for different database such as SQL Server,Oracle,Sybase and DB2,but also universal in different programming language such as VB,VC,VJ,and Delphi,so it is very useful.

摘要: 现有安装程序(如Installsheild、InstallFactory等)在解决用户数据库的自动部署时,操作步骤非常复杂和繁琐,不易掌握和使用。针对这一问题,提出了利用SQL和ADO编程来实现用户数据库的自动部署的方法。该方法对于大多数数据库管理系统(如SQL Server、Oracle、Sybase、DB2等)具有通用性;并且没有编程语言的限制,对VC、VJ、VB、Delphi等都适用,使用简便,具有较高的实用性。