Promotic
WikipediaLinkedInYoutubeTwitterFacebook

PmDbAdmin - administration of SQL databases

Usage

PmDbAdmin is a tool that serves for simple administration of databases (at present only MS SQL Server). It is adjusted first of all to the administration connected with PROMOTIC system needs to these databases. The tool uses the graphic HTML interface, it uses JAVA scripts and the ADO interface, the technology from Microsoft, is used for accessing databases. The ADO technology is a part of new operating systems (WindowsXP Prof,...). For older operating systems the ADO technology is installed together with installation of the PROMOTIC system.

The PmDbAdmin application is located by default in the disk folder C:/Pm/Tools/PmDbAdmin/PmDbAdmin.chm.

First start of PmDbAdmin tool

The first usage of the tool assumes that one version of the SQL database server was installed - see MSSQL.Install and that this server is local or accessible in LAN network. Further, it is advisable to register the usage of the ADO technology in the Windows registry editor. By this, the security notifications that warn users about using ADO, are disabled. The registration is done by the confirmation in the window called by the 'Registration ActiveX ADO' link on the opening page. On the opening page there is also preset the login window by default that assumes the location of the database server to the local computer (otherwise the name of the database server in the network), the user name is sa (system administrator) and the user password is blank. The connection is done by the Connect to the server button or by the Enter key confirmation.

After connection to the Information page, the information whether the server is configured by the PROMOTIC system, is marked. In the administration mode sa there is then the possibility to make or remove this configuration. These actions have nearly the same function as the configuration operations described in MSSQL.Install. The only difference is the possibility to change preset passwords for created user accounts.

© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice