...
- Give it the Alias "<OC-Name> JDBC"
- Select the vjdbc driver
- Enter the database URL: "jdbc:vjdbc:rmi://145.9.227.80:2000/VJdbc,FewsDataStore". The number "145.9.227.80" is the IP adress of the Server where the database is located. (you can get the IP adress by typing ipconfig in the command line of the Server). The number "2000" is the default port number, the correct port number is shown in the FEWS log file on the Server when it is started.
Setting up a ODBC-JDBC bridge
The FEWS JDBC Server has been tested with the Easysoft JDBC-ODBC bridge, this can be purchased. This allows the user to access the JDBC Server from other applications like Microsoft ACCESS that do only support ODBC. To use the JDBC driver with the ODBC-JDBC bridge, do the following:
- Install the Easysoft JDBC-ODBC bridge
- Go to the Windows Start Menu -> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC)
- Select the System DDS tab and add a new data source.
- Make sure you add the vjdbc.jar and commons-logging-1.1.jar file to the classpath
- The url is: jdbc:vjdbc:rmi://<host>:2000/VJdbc,FewsDataStore (under <host>, enter the machine where the fews jdbc application runs)
When the FEWS JDBC application runs you can test the connection using the Test button.