Configuring the Database Connections

For each database that Kapow Web Data Server should be able to use, you must configure a connection from Kapow Web Data Server to the database. This is done in the “Database Connections” tab of the Settings application, shown below.

Configuring Database Connections in Settings

In the left side of the window is a list of the created connections. You can create new connections, remove connections, or change their order, using the buttons below the list. The currently selected connection is configured in the right side of the window.

A connection is configured using the following properties:

Property

Description

Database Name

The name of the database as seen from inside Kapow Web Data Server. Note that this is different from the “Host Database Name” below, although you can use the same name here if desired.

Database Type

The type of database, e.g. Oracle.

Host

The host name of the database server. This can be an IP-address, or the fully qualified domain name, e.g. myhost.kapowtech.com.

Host Database Name

The name of the database on the database server.

User Name

The user name for the database.

Password

The password for the database.

Port Number

The port number on the database server. Leave it blank to use the default port number for the database type that you have selected.

Character Encoding

If the database uses a special character encoding you can enter the encoding here. Please refer to your database documentation for information on the name of the encoding.

Max Concurrent Connections

The maximum number of concurrent connections to the database.

Connection Properties


You can test the current connection by pressing the “Test Connection” button. Note: This will only test the connection to the database, it will not test that you have the proper permissions in the database.

Connecting to Oracle: If you are using an Oracle database, you need to enter a user name and a role in the “User Name” property. For example, if the user name is “sys”, and the role is “sysdba”, you should enter “sys as sysdba” in the “User Name” property.

Connecting to DB2: To connect to your DB2 database, you need to start a special server on the database server — one which enables Java programs to connect to the database. To start the server, locate the file named db2jstart on the database server, and start it with the command db2jstrt 6789. You are also required to install the JDBC driver for DB2. The JDBC driver is included in your database installation. Look for a file called db2java.zip. When connecting to version 8.2 you should also copy db2jcc.jar. You must copy that file to your installation. On Windows, the default destination directory is:

C:\Program Files\Kapow Web Data Server 7.0\lib\jdbc\

On Linux, the default destination directory is:

~/Kapow_Web_Data_Server_7_0/lib/jdbc/

Connecting to Microsoft SQL Server 2005: To connect to your Microsoft SQL Server 2005, you must download the SQL Server 2005 JDBC driver from http://www.microsoft.com. The download contains a file named sql2005jdbc*.jar. You should copy this file to your installation. On Windows, the default destination directory is:

C:\Program Files\Kapow Web Data Server 7.0\lib\jdbc\

On Linux, the default destination directory is:

~/Kapow_Web_Data_Server_7_0/lib/jdbc/

Connecting to Microsoft SQL Server 2000: To connect to your Microsoft SQL Server 2000, you must download the Microsoft SQL Server 2000 Driver for JDBC from http://www.microsoft.com. The download contains three files named msbase.jar, mssqlserver.jar, and msutil.jar. You must copy these files to your installation. On Windows, the default destination directory is:

C:\Program Files\Kapow Web Data Server 7.0\lib\jdbc\

On Linux, the default destination directory is:

~/Kapow_Web_Data_Server_7_0/lib/jdbc/

Connecting to Microsoft SQL Server 7.0: To connect to your Microsoft SQL Server 7.0, you must buy the Sprint driver from i-net software http://www.inetsoftware.de/English/produkte/JDBC2/Default.htm. It is possible to download a trial version. The download contains a file named Sprinta2000.jar. You must copy that file to your installation. On Windows, the default destination directory is:

C:\Program Files\Kapow Web Data Server 7.0\lib\jdbc\

On Linux, the default destination directory is:

~/Kapow_Web_Data_Server_7_0/lib/jdbc/

Connecting to MySQL: To connect to your MySQL, you must download the MySQL JDBC driver (MySQL Connector/J) from http://www.mysql.com. The download contains a file named mysql-connector-java-*-bin.jar. You should copy this file to your installation. On Windows, the default destination directory is:

C:\Program Files\Kapow Web Data Server 7.0\lib\jdbc\

On Linux, the default destination directory is:

~/Kapow_Web_Data_Server_7_0/lib/jdbc/

Connecting to PointBase Server: If you are using PointBase Server 4.3, you must either upgrade to version 4.4, 4.5, or obtain the latest 4.3 patch from PointBase. To connect to your PointBase Server, you must copy the PointBase JDBC driver from your database installation to your installation. The driver can normally be found in the PointBase installation directory, under lib. The file name is pbclient43.jar (for PointBase version 4.3), or pbclient44.jar (for PointBase version 4.4). Copy this file to your installation. On Windows, the default destination directory is:

C:\Program Files\Kapow Web Data Server 7.0\lib\jdbc\

On Linux, the default destination directory is:

~/Kapow_Web_Data_Server_7_0/lib/jdbc/

Prev Setting up the RoboManager Databases    Specifying a Proxy ServerNext