Install a DataSource in the Java 2 Enterprise Manager (J2EE) Version 1.3

Copy the driver archive into the directory $J2EE_HOME/lib/system.
Add the driver archive Opta.jar to the classpath of the J2EE. The classpath of J2EE is set with the environment variable J2EE_CLASSPATH (please note: not with CLASSPATH). However, we recommend that you set J2EE_CLASSPATH in the user configuration script. On UNIX the user configuration script is in bin/userconfig.sh, and on Windows it is in binuserconfig.bat.
Add the driver (for XA DataSource and non XA DataSource) (for all MS SQL Server drivers)
- via command line: j2eeadmin -addJdbcDriver com.inet.tds.TdsDriver
- or add the following lines to your config file resource.properties:
```
jdbcDriver.1.name=com.inet.tds.TdsDriver
```
  (replace 1 with the next free number)
Add a XA DataSource (only with i-net OPTA and i-net MERLIA)
- via command line: j2eeadmin -addJdbcXADataSource {jdbc/XASqlServer} com.inet.tds.DTCDataSource {sa} “{}” -props serverName={YourSQLServerHost} databaseName={YourDatabase}
- or add the following lines to your config file resource.properties:
```
xadatasource.1.name={jdbc/XASqlServer}
xadatasource.1.classname=com.inet.tds.DTCDataSource
xadatasource.1.dbuser={sa}
xadatasource.1.dbpassword={}
xadatasource.1.prop.databaseName={YourDatabase}
xadatasource.1.prop.serverName={YourSQLServerHost}
```
  (replace 1 with the next free number). You will find a list of the properties in the API doc of TdsDataSource, the parent of XDataSource. The setter/getter methods are properties that can be set. (everything within {} is to be replaced by your value including the {}): *** 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.
Add a DataSource without XA (named JDBC 1 DataSource) (for all our MS SQL Server drivers)
- via command line: j2eeadmin -addJdbcDataSource {jdbc/SqlServer} jdbc:inetdae7:{YourSQLServerHost}?database={YourDatabase}&user={sa}&password={}
- or add the following lines to your config file resource.properties:
```
jdbcDataSource.5.name={jdbc/SqlServer}
jdbcDataSource.5.url=jdbc:inetdae7:{YourSQLServerHost}?
database={YourDatabase}&user={sa}&password={}
```
  (replace 5 with the next free number)

Install a DataSource in the Java 2 Enterprise Manager (J2EE) Version 1.3

You might also want to visit