...
The database connector download comes with several pre-installed drivers. See [[#Install_a_JDBC_driver | IInstall a JDBC driver]] below below.
Installation Steps
Throughout this documentation we are using the frevvo-tomcat bundle as the installation location for the database connector. This is just an example as the connector will work under any compatible servlet container. This documentation assumes that the frevvo-tomcat bundle is installed in c:\frevvo. We'll refer to this directory below as <frevvo-home>.
If you have already downloaded the frevvo-tomcat bundle for Live Forms In-house then you already have the database connector. It is located in the unpacked frevvo-tomcat bundle in <frevvo-home>\frevvo\ext\connectors and is named database.zip. If not or if you wish to download the latest version then [http://www.frevvo.com/frevvo/web/download/DB download the database connector] from the from the frevvo web site. You will need to login with your frevvo account
Follow these steps to install the connector:
1) Unpack the database.zip file to a temporary location of your choice: e.g. c:\tmp. This will create a folder c:\tmp\database. We'll refer to this directory below as <db-tmp>
2) Copy <db-tmp>\database.war to <frevvo-home>\tomcat\webapps*
- If frevvo is running this will automatically expand database.war into a <frevvo-home>\webapps\database sub folder
3) If frevvo is not running, start frevvo: Double click <frevvo-home>\start-frevvo*
- This will start frevvo and it will automatically expand database.war into a <frevvo-home>\webapps\database sub folder
4) [[#Starting_and_Testing_the_Connector | Test the connector installation]] by by copying this Url directly into your browser: http://localhost:8082/database/myStore/allOrders
...
- Review the previous installation steps
- See [[#Starting_and_Testing_the_Connector | starting and testing the connector installation]] for for more detailed instructions and common problems.
- If you cannot get the database connector working please see [[Getting_Help | Getting Help]] to to contact frevvo support.
Follow these steps to configure the connector:
...
If you don't find what you need pre-installed you will need to locate a driver compatible to your database. Usually you can download your driver from the internet. Try one of these locations
- [http://msdn.microsoft.com/en-us/sqlserver/aa937724 SQL Server JDBC Driver]
- [http://www.oracle.com/technetwork/database/features/jdbc/jdbc-112010-090769.html Oracle][https://www-304.ibm.com/support/docview.wss?uid=swg21363866 DB2
- DB2[ DB2]
- [http://dev.mysql.com/downloads/connector/j/ Mysql]
...