Page History

...

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 UTF-8 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.

...

1. Locate the userDS data source url parameter: url="jdbc:jtds:sqlserver://localhost/users". You can change the name "users" to whatever you wish, "

   Frevvoproduct

    users" for example. But it must match the database name you create in your SQL server. See verify connection Url below.
2. Create a utf8 UTF-8 encoded database "users" (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/users-<database type>.sql. Ex: for mySQL the script is named <frevvo-home>/data/sql/users-mysql5.sql
4. Run that script in the "users" database
5. Set the userDS data source username and password parameter to a user that has write permissions to your "users" database.

...