SQL Anywhere Instructions

  1. Open Sybase Central
  2. Click on Tools -> SQL Anywhere 12 -> Create Database...
  3. In the Create Database Wizard click Next
  4. Under Select a Location choose Create a database on this computer and click Next
  5. Under Specify a Database File click Browse..., navigate to dbiScript\data, enter clinic.db as the File name, click Save and then click Finish
  6. When the database has been created, click Close in the Creating Database window
  7. Under Database Design Tasks in the sidebar, click Create a user
  8. Enter "clinic" as the user name and click Next>
  9. Ensure Assign a password to this user is checked, enter a paassword and click Next>
  10. Check DBA and click Finish
  11. Click on Tools -> SQL Anywhere 12 -> Open Interactive SQL
  12. Enter "clinic" as the User ID, enter then password from the previous step and then click Connect
  13. Click File -> Open and select the clinic.sql file from this folder
  14. Click on the Execute all SQL statement(s) icon and then close the Interactive SQL window
  15. Click on Connections -> Connection Profiles (F9)
  16. Click on New…
  17. Enter "Clinic" for the Name
  18. Click on OK
  19. The Edit Connection Profile window should open automatically
  20. Enter "clinic" for the User ID and enter the password from the previous step
  21. Ensure the clinic.db file is set as the Database file
  22. Click on Save
  23. If you'd like the Clinic connection to be opened whenever Sybase Central is started, click Set Startup
  24. Click on Close in the Connection Profiles window
  25. Close Sybase Central
  26. Open the clinicSQLAnywhere.cfg file in this folder
  27. Replace the orange text in the following line with the password chosen in step 9:

    connectionString = "DBF=../data/clinic.db;UID=clinic;PWD=password"

    Note: The path is relative to dbiScript\bin\Cyberaxiom.dbiScript.dll

  28. Move the clinicSQLAnywhere.cfg file from this folder to the dbiScript\data folder
  29. In the dbiScript\apps\clinic\clinic.js file change the following line

    app.dbiScriptProperties.dataConfig = "../data/clinic.cfg"

    to

    app.dbiScriptProperties.dataConfig = "../data/clinicSQLAnywhere.cfg"

  30. Navigate to http://localhost/dbiScript/apps/clinic/