Implement of key technologies in developing MIS on Client/Serve
LU Bing-liang · Journal of Shenyang Institute of Aeronautcal Engineering · 2004
This paper introduce technologies and methods of efficient and security accessing Database in developing management information system based on Client/Serve. The methods include Database security , application programm security and ADO technology. First, users ID and passwords are set up for views and stored procedures in Database Server(SQL Server); Second, user group tables of all application programming are configured in Database Server and all the permissions are stored in these tables.So that applying program are allowed to access the Database. Finally , three object(Connection、Command、Recordset) of ADO technology are applied. These technology implements efficient and security access data of Database Server(SQL Server)