...
- Locate the frevvoDS data source url parameter.url="jdbc:jtds:sqlserver://localhost/frevvo"/>. You can change the name "frevvo" to whatever you wish, " for example. But it must match the database name you create in your SQL server. See verify connection Url below.
- Create a utf8 encoded database ""frevvo" (assuming you left the url parameter database name as the default) in your SQL server
- In the 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 that script in your "" 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 "" database.
- The submissions database setup is now complete.
...
Configuration of the connection Url is key to successfully connection connect the server to your database. Consult your DBA to assist with connection issues.
...
As of SQL 2000, Microsoft SQL allows installation of multiple SQL named instances. If your SQL server was installed this way you must use the instance parameter. For example if you database instance was named xyzzy:
| Code Block |
|---|
{<url>jdbc:jtds:sqlserver://e00sca:59377/frevvo;instance=xyzzy</url> |
...