About Database Settings

You can configure the Database component to operate with different databases, such as MS Access, DB2, Oracle, and SQL Server.

Related Topics
Modifying the Isight Class Path

Depending on the database you are using, you may need to make the following changes to use the Database component. For more information, refer to your database documentation or contact your local database administrator.

MS Access

Do the following to configure the Database component to operate with an MS Access database:

  • Set the primary column to YES.

  • Some MS Access databases may need the Windows ODBC setting to create the database.

  • Set the environment to the user database classpath for database license distribution.

Oracle

The Database component is a general usage database. If you use a special Oracle datatype such as CLOB, place the ojdbc14.jar file in the Oracle directory. You also need to add this file with the full path to the Isight class path.

DB2

If you are trying to connect to a remote DB2 database, select the following driver from the driver list when connecting to a database using Isight:

  • com.ibm.db2.jcc.DB2Driver

Then, add the following files with the full path to the Isight class path:

  • db2jcc.jar
  • db2jcc_license_cisuz.jar
  • db2jcc_license_cu.jar

SQL Server 2000 – Type 2 Driver

If you are trying to connect to a Microsoft SQL Server database using the Type 2 driver, download the following Type 2 driver file:

  • Microsoft SQL Server 2000 Driver for JDBC

Then, add the following files with the full path to the Isight class path:

  • msbase.jar
  • mssqlserver.jar
  • msutil.jar

You need a valid user name and password.

SQL Server 2000- Type 4 Driver

If you are trying to connect to a Microsoft SQL Server database using the Type 4 driver, download the following Type 4 driver file:

  • Microsoft SQL Server JDBC Driver

Then, add the following file with the full path to the Isight class path:

  • sqljdbc.jar

You need a valid user name and password.