How to Update Control License Information
The Control License Update program is provided to allow the customer to update their license information when they receive a new Control license file. The following instructions describe how to run this update program.
In order to use this program, you will need a Control serial file. You should have received this file from KCI Computing, or one of its representatives.
Note: This program should be run only from a system that has been set up to run Control, as the update program is dependent on the Control system to run.
1. Launch the Control License Update program. A program called UpdateControlLicense is located in the \Utility folder of the Control installation directory. Double-click on this file to launch the Control License Update program. The Control License Update dialog box will appear:
2. Fill out the prompts in the dialog.
Please note that this program will record your keystrokes exactly in uppercase or lower case as you enter them, so be careful of the case you enter.
§ Database User ID is the valid account (CNTADM) on the SQL database server that currently owns all the Control tables. If the User ID was created in uppercase on the database server, it should be entered here in uppercase also.
§ Database Password is the RDBMS password to this account. For certain SQL databases this password may be case sensitive. Make sure to enter it in the correct case.
§ Database Server is the name of the database to connect to, or the connect string for the database.
· Oracle: the database name as defined in Net10 or QLNet11 client.
· Microsoft SQL Server 2005, 2008, 2008 R2, 2012 or 2014: the name of the ODBC data source that was created to access the SQL Server 2005, 2008, 2008 R2, 2012 or 2014 database.
· Sybase: the database name defined in the DSEDIT program.
· UDB: the name of the ODBC data source that was created to access the iSeries or AS400 system where the CONTROL database is.
· Any ODBC database: the data source name as defined in the ODBC Administrator program.
§ Database Type is the type of SQL database server to which Control is connected. Select MS SQL Server if talking to Microsoft SQL Server, and Sybase if talking to Sybase SQL Server.
§ The Update program will create a file named Log file in order to record the results of the update process. If the file entered already exists, or if the directory is not valid, you will be asked to re-enter the file name.
§ Serial File is the name of a file that contains your Control license file, which is used to update your user counts. The Update program will check to see that the file you have entered is valid; if not, the Update program will ask you to re-enter the file name.
3. Press Update to start the update process.
The Control License Update program will attempt to connect using the given User ID and password. Next, the Control License Update program will check the database to see that the specified database account has the correct permissions:
· CREATE TABLE
· GRANT
· INSERT
· UPDATE
· DELETE
· DROP TABLE
If the Control License Update does not succeed with these tests, the program will return you to the main Control License Update dialog.
If the permission tests succeed, the Control License Update program will then check to make sure that there is a Control system on the SQL database server. If the Control License Update program does not find a version Control system, the program will ask you if you wish to continue with the update process.
The Control License Update program will then try to update the Control license information. If Control License Update program was not able to connect, it will tell you so. You should check to make sure that it is possible to do so from this machine. If the Control License Update program encounters any errors during its execution, they will be displayed on the screen.
Assuming that Control License Update program runs to completion, the program will disconnect from the database and let you scroll through the log window to review the results. Click the Close button to close the log window and return to the main Control License Update program dialog. Select the Close button to exit the program.
The Control License Update program will create a log file in the Control directory that will list all the steps that were performed. If there was a problem during the update, this file will be useful in determining where the problem occurred.