How do I connect to Pro/5 Database using GoAnywhere?
Posted: Fri Mar 06, 2009 9:08 am
The standard install of GoAnywhere does not ship the driver for Pro/5 Database, however, you can manually install the JDBC driver. Follow the instructions below to install the Pro/5 JDBC Driver:
- Download the JDBC driver from http://www.basis.com
- Copy the BBjJDBC.jar to the system where GoAnywhere is installed. The location to copy is GA_INSTALL_DIR/WebRoot/WEB-INF/lib.
- Restart GoAnywhere Service/Subsystem
- Log in to GoAnywhere
- Add/Edit a Database Resource
- In the JDBC Driver field, type com.basis.jdbc.BasisDriver
- In the JDBC URL field, type jdbc:basis:<server>:<port>?database=<database_name>. Substiltute <server> with the host name or IP address of the Pro/5 database server. Substitute <port> with the port number on which the Pro/5 database server is listening. Substitute <database_name> with the database that you would like to connect. For configuring advanced options that the driver supports, use the JDBC URL Wizard helper tool.
- Enter the database login in the User Name and Password fields.
- Click on Test button to see if the database connection goes through.