Update the crash database connection information
|Top Previous Next|
Clients that have purchased a configuration will need to update the connections to point to their internal collision database. In general Pd' Programming creates configurations based on a sample copy of the clients collision database. Configurations sent to users therefore contain database connection information for sample database at Pd' Programming, and must be changed. Each configuration can contain one or more connections to the collision database. The information required by these connections should be provided by the database administrator of the collision data. Here is how to locate the connections:
In this example two connections are available for the CO@PdProgramming user group. A DataEntry and Default connections are shown in this example.
Here is how to change a connection string:
Once the connection string is changed the login and password information will need to be updated. There are two options for Crash Magic logins. Standard Crash Magic logins or DBVerify.
The standard option allows a single database login to be specified. This will cause Crash Magic to use this login to query the collision database. In this case user logins and passwords must be managed in Crash Magic. In this case you will enter a valid login and password into the Login and Password fields of the connection string. Default analysis connections require only select access to the collision tables. If you are setting a connection for Data Entry then a login and password that has select, insert, update and delete privileges must be used.
DBVerify allows Crash Magic to pass the login name(User id on the login page) and password on to the database for verification. This allows for user logins and passwords to be managed with the database. Click the Set for DBVerify login link to set the login and password fields to use DBVerify.
Some database use roles to manage permissions on the database. A default empty role is included in the configuration. Roles defined under the .shared user will be displayed in the Role drop down list. If your logins require roles on the database you may need to add or change the roles provided. See the Roles section of the manual.
The connection to the database can be checked using the the Test button. Clients using DBVerify can test their connection string by entering a Login name and password, but the connection must be set back to DBVerify when complete. A successful test will display "Test connection succeeded." along with information on the database driver in use.
With the installation and setup of Crash Magic complete users can now be added to Crash Magic.