Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Locate the frevvoDS data source url parameter.url="jdbc:jtds:sqlserver://localhost/frevvo". You can change the name "frevvo" to whatever you wish, "
    Frevvoproduct
    " for example. But it must match the database name you create in your SQL server. See verify connection Url below.
  2. Create a utf8 encoded database "frevvo" (assuming you left the url parameter database name as the default) in your SQL server
  3. In the
    Frevvoproduct
     installation locate the script <frevvo-home>/data/sql/forms-<database type>.sql. Ex: for mySQL the script is named <frevvo-home>/data/sql/forms-mysql.sql
  4. Run that script in your "
    Frevvoproduct
    " database. That will create all the tables required to persist submissions
  5. Set the frevvoDS data source parameters username and password to a user that has write permissions to the "
    Frevvoproduct
    " database.
  6. The submissions database setup is now complete.

Configure the LiveForms Live Forms users database

For your selected database type in frevvo.xml,

...