How do I connect to Pro/5 Database using GoAnywhere?

View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere Director. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.
1 post Page 1 of 1

Support_Ron

Support Specialist
Posts: 10
Joined: Tue Mar 03, 2009 5:45 pm

Post by Support_Ron » 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.
Once the resource is setup, create projects using the resource to read/write data to the database.
1 post Page 1 of 1