background image

Access

Database Assistant

2 of 7

Access

Make sure the Host Connection light is green and indicates the status is Operational.  (If it is not green or it 
does not say Operational, see the section on Trouble Shooting ).  This screen is used to view current user 
login and access level information.  This screen is also used to change user passwords.

Changing Passwords

To change the password for the Normal user, delete the current password located in the field labeled 
Normal.  Enter a new password.  Then, click on Save.  

To change the password for the Super User, delete the current password located in the field labeled Super 
User.  Enter a new password.  Then, click on Save.

Log In / Log Out

This button is used to log in or log out of Database Assistant.

Access Level

This displays the access level for the current user.

Normal

This field displays the current password for the Normal user.  This field 
is only displayed for Super User.

Super User

This field displays the current password for the Super User.  This field is 
only displayed for Super User.

Summary of Contents for Strata CIX Database Assistant

Page 1: ... Voice Assistant 4 1 or higher is also required The Microsoft ODBC Drivers must be installed prior to installing Database Assistant Follow these steps in order 1 Install Voice Assistant 2 Install the Microsoft ODBC Drivers which are included Even if you are using a different ODBC Driver for a different database these drivers need to be installed for Database Assistant to run properly 3 Reboot the ...

Page 2: ...current password located in the field labeled Normal Enter a new password Then click on Save To change the password for the Super User delete the current password located in the field labeled Super User Enter a new password Then click on Save Log In Log Out This button is used to log in or log out of Database Assistant Access Level This displays the access level for the current user Normal This fi...

Page 3: ...Connection 1 Click on the Create button under the ODBC Connection Controls section under the ODBC Setup tab 2 The Select Cursor Driver screen will appear Select the Cursor Driver to use for the ODBC connection Then click on Ok to bring up the Select Data Source window 3 Click on Machine Data Source and then click on New 4 Enable the System Data Source radio button then click on Next 5 Choose the a...

Page 4: ...etup screen 11 The Data Source Name you entered should now appear in the ODBC Connections section Delete an ODBC Connection Highlight the ODBC Connection you wish to delete in the ODBC Connection section and click on the Delete button SQL Statements This section is used to add edit delete and test SQL statements For more detailed information about SQL Statements see the section labeled SQL Stateme...

Page 5: ... is used to set up the Host Manager for Database Assistant Upon entering this screen for the first time enter VA_HOST in the Host Manager box Click Save Chg The upper right corner light should switch to green and Host Connection should be Operational ...

Page 6: ...tements Add an SQL Statement To add an SQL Statement make sure your database is highlighted in the ODBC Connections box located next to the SQL Statements box in the ODBC Setup screen Then click on Add SQL to bring up the Add SQL Statement screen This screen allows us to create an SQL Statement that can be used by Voice Assistant Name Enter the name you wish to give your SQL Statement Timeout Ente...

Page 7: ... highlight the statement you wish to edit and click on the Edit SQL button This will bring up the Add SQL Statement box where you can make the desired changes Using SQL Queries The queries are activated using the REQ_DBACT command in Voice Assistant scripts see the Operations Manual for more details End of Document Tables This box lists all of the tables found in your selected database If you high...

Reviews: