...
- Locate the '''frevvoDS''' data source url parameter.<nowiki>url="jdbc:jtds:sqlserver://localhost/frevvo"/></nowiki>. You can change the name "frevvo" to whatever you wish, "frevvoformsLive Forms forms" for example. But it must match the database name you create in your SQL server. See [[#Verify_Connection_Url | verify connection Url]] below.
- Create a [[#UTF8_Encoded_Database | utf8 encoded]] database "frevvo" (assuming you left the url parameter database name as the default) in your SQL server
- In the Live Forms installation locate the script <frevvo-home>/data/sql/forms-<database type>.sql. Ex: for mySQL the script is named <frevvo-home>/data/sql/forms-mysql5.sql
- [[#Run_the_SQL_Scripts | Run that script]] in your "Live Forms" database. That will create all the tables required to persist submissions
- Set the '''frevvoDS''' data source parameters username and password to a user that has write permissions to the "Live Forms" database.
- The submissions database setup is now complete.
...
- Locate the '''userDS ''' data source url parameter.<nowiki>url="jdbc:jtds:sqlserver://localhost/users"/></nowiki>. You can change the name "users" to whatever you wish, "Live FormsusersForms users" for example. But it must match the database name you create in your SQL server. See [[#Verify_Connection_Url | verify connection Url]] below.
- Create a [[#UTF8_Encoded_Database | utf8 encoded]] database "users" (assuming you left the url parameter database name as the default) in your SQL server
- In the Live Forms 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
- [[#Run_the_SQL_Scripts | Run that script]] in the "users" database
- Set the '''userDS''' data source username and password parameter to a user that has write permissions to your "users" database.
...