How to install i-net OPTA in IBM WebSphere 5.0 to connect to MS SQL Server

  1. Start the “Administrative Console” of WebSphere 5 with the URL: "http://ServerName:9090/admin".
  2. Open the node “Resources” and select “JDBC-Providers” in the three on the left side.
  3. Select “Server” and click “Apply” in the “Scope” section if “Server” is not selected already.
  4. Click on the “New” button to create a new JDBC provider.
    websphere_jdbcprovider.jpg
  5. Select “User-defined JDBC Provider” in the choice “JDBC Providers” under “General Properties” and click “OK”.
    websphere_newjdbcprovider.jpg
  6. Enter the display name for this JDBC driver (e.g. i-netOptaDriver) in the field “Name”.
  7. Enter the path of the driver (e.g. /opt/Opta2000.jar) in the field “Classpath”.
  8. Enter the class name of this driver (e.g. com.inet.tds.TdsDriver) in the field “Implementation Classname”.
    websphere_jdbcprovider_config.jpg
  9. Click on “OK” and the new JDBC provider (driver) has been created.
  10. Now select your new JDBC driver and click on “Data Sources (Version 4)” in “Additional Properties” to create a WebSphere 4.x data source.
  11. Click on the “New” button.
    websphere_jdbcprovider_newdatasource4.jpg
  12. Enter a name for this data source in “Name” (e.g. SQL Server Data Source).
  13. Enter the jndi name in “JNDI Name” (e.g. jdbc/SqlServer).
  14. In the field “Default User ID” enter the username for your database.
  15. In the field “Default Password” enter the password for this user.
    websphere_jdbcprovider_datasource4.jpg
  16. Click “OK” and the new datasource has been created.
  17. Now click on the new data source.
  18. Click on “Custom Properties” in the section “Additional Properties”.
  19. After you have clicked on the “New” button you must enter a “databaseName” in the field “Name”.
  20. In the field “Value” enter the name of the database.
    websphere_jdbcprovider_datasource4_props.jpg
  21. Click “OK”
  22. Now enter in the same way the values for “user”, “password” and “serverName”.
  23. After this you should have the following four entries in the “Custom Properties” list.
    websphere_jdbcprovider_datasource4_allprops.jpg
  24. Click on “Save” and the data source configuration is finished!
    websphere_jdbcprovider_datasource_save.jpg
 

© Copyright 1996 - 2017, i-net software; All Rights Reserved.