If you are using iNet drivers with WebLogic, when you create your data source, use the following settings:
The type should be DataDirect’s MSSQL type 4 XA.
Set the following properties:
url
—The full connection string for your data source.driver
—The driver name iscom.inet.tds.DTCDataSource
.user
—User name for the database account.port
—Connection port used for the database.mode
—This should normally be set to 71, as Unicode is not supported for MS SQL.serverName
—The machine name of the database host.secureLevel
—Set this to 0 if you are not using SSL. If you are using SSL, see your database documentation for information.