Creating a database connection with a different JDBC driver class

If you need to use a different JDBC driver class other than the classes provided by IBM® Web Services Navigator select Other in the JDBC driver class field, and enter the JDBC driver class file path and the JDBC URL as needed.

The following example uses the Other JDBC driver value and enables you to specify own connection parameters:

Figure 1. Specifying database connection parameters for a Microsoft SQL Server 2000 connection.

To create a database connection with a different JDBC driver class, follow these steps:

1. In the Select a database manager area, expand the Microsoft SQL Server node and select 2000.
2. In the JDBC Driver field, select Other.
3. In the Connection URL details area, complete the following steps:
   1. In the Database field, select the appropriate database name from the selection list, for example, WPROXY. If you are not sure which name to select, see your database administrator for assistance.
   2. In the JDBC driver class specify the com.microsoft.jdbc.sqlserver.SQLServerDriver value.
   3. In the Class location field, specify the following JAR files, all on a single line, separated by semicolons:
      • <SQL_HOME>\lib\msbase.jar
      • <SQL_HOME>\lib\mssqlserver.jar
      • <SQL_HOME>\lib\msutil.jar

      The <SQL_HOME> directory path is where the Microsoft SQL Server 2000 Driver for JDBC is installed, for example, C:\Program Files\Microsoft SQL Server 2000.

   4. In the Connection URL field, specify the connection URL in the following format:

      jdbc:microsoft:sqlserver://<servername>:<port>;user=<user>;
        password=<password>;databaseName=<database>

      The following variables are used:

      <servername>

      The fully qualified name of the system where Microsoft SQL Server is installed.

      <port>

      The port number, typically 1433.

      <user>

      The user ID authorized to access the database, for example, user01.

      <password>

      The valid password associated with the specified user ID.

      <database>

      The name specified in the Database field, for example, WPROXY.

      For other third party SQL JDBC drivers: Consult your SQL JDBC driver publications for the correct URL information to enter into this field.

4. In the Specify user information area, select the appropriate user ID and password to access the database, either the operating system sign-on values, or another authorized user ID and password.