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

Start the WebSphere Console

Select the node “JDBC Drivers”

Click on the “New” button and add the driver.

Select “User-defined JDBC Driver”.

Edit the driver properties.

*** If you can't install the Resource Manager Proxy in the SQL Server then you can use com.inet.tds.XDataSource instead of com.inet.tds.DTCDataSource.

Select the “Data Sources” Node of the driver and click on the “New” button.

You need to add a name (for example sqlserver) and a JNDI name (for example jdbc/sqlserver)

Add driver specific properties to the datasource.

After you installed the JDBC driver from i-net software please check if your config.xml (located in the config directory of your WebSphere application server) contains jtaEnabled=“true”.

<resourceProviders xmi:type="resources:JDBCDriver" xmi:id="JDBCDriver_3"
                  name="i-net Opta" description="MS SQL Server XA driver from i-net" 
                  implementationClassName="com.inet.tds.DTCDataSource">
 
    <urlPrefix xsi:nil="true"/>
    <factories xmi:type="resources:DataSource" xmi:id="DataSource_9" name="O" 
               jndiName="jdbc/sqlserver" jtaEnabled="true"
               statementCacheSize="100" defaultUser="sa" defaultPassword=""
               disableAutoConnectionCleanup="false">
 
        <propertySet xmi:id="J2EEResourcePropertySet_9">
            <resourceProperties xmi:id="J2EEResourceProperty_15" name="serverName" 
                                type="java.lang.String" value="LocalHost">
                <description xsi:nil="true"/>
            </resourceProperties>
 
            <resourceProperties xmi:id="J2EEResourceProperty_16" name="databaseName" 
                                type="java.lang.String" value="master">
                <description xsi:nil="true"/>
            </resourceProperties>
        </propertySet>
    </factories>
    <propertySet xmi:id="J2EEResourcePropertySet_1"/>
</resourceProviders>