SQL Server with Merant Database Configuration

 

The instructions below describe how to configure SQL Server using a Merant Database to work with the WebSphere Application Server Samples.

Create the SAMPLE Database

Create the Sample DataSource Object

  1. Point your browser to the WebSphere Application Server Administrative Console:
    http://localhost:9090/admin.
  2. Create the Merant JDBC Driver:
  3. Create the Sample DataSource Object:

Remove the Samples IDB DataSource Object

  1. Point your browser to the WebSphere Application Server Administrative Console:
    http://localhost:9090/admin.
  2. Expand Resources > JDBC Drivers > idbJdbcDriver and click Data Sources.
  3. Select the box next to Samples IDB DataSource and click Delete.
  4. Save your configuration.
  5. Shut down and restart WebSphere Application Server.

Run the Database Servlet

Run the servlet to create and configure the tables in the SAMPLE database.