Installing the MS SQL 7.0 JDBC driver

To integrate the Avaya IR system with an MS SQL Server 7.0 database, you must install the JDBC driver for MS SQL Server 7.0.

To download the JDBC driver for MS SQL Server 7.0:

1. From a Web browser, go to the ThinWEB Technologies Web site and locate the download links for the JDBC driver ThinTDS or TWFreeTDS.

   Note:
   Avaya has performed system testing with TWFreeTDS. For commercial applications, ThinTDS is recommended. If you cannot locate ThinTDS or TWFreeTDS, perform a Web search with the term MS SQL JDBC driver. Avaya cannot guarantee the performance of untested drivers.

2. Download the .jar file or .zip file, for example TwFreeTds_1.3.zip, and save it to a PC.
3. If the downloaded file is a .zip file, extract the .jar file from the .zip.
4. Transfer the .jar file (using the ftp command or some other method) to the /tmp directory on the Avaya IR system.
5. Log on to the Avaya IR system as root.
6. Enter cd /tmp to go to the directory that contains the .jar file.
7. Enter cp filename.jar /vs/java/sqlserver.jar to copy the .jar file to /vs/java directory of the Avaya IR system and to rename it as sqlserver.jar.
8. Enter ls /vs/java to display the contents of the java directory and to verify that the sqlserver.jar file was successfully copied and correctly renamed.

To administer the MS SQL 7.0 DIP:

1. Enter /etc/init.d/tomcat stop

   The system displays messages indicating that the Tomcat engine is stopped.

2. Enter /etc/init.d/tomcat start

   The system displays messages indicating that the Tomcat engine is started.

3. Use a browser to access Avaya IR Web Administration and view the JDBC Administration - Main screen.
4. Click the Dipid of the data interface process (DIP) you want to administer.

   The JDBC Administration - Edit screen for the selected DIP is displayed.

5. Select MS SQL Server as the Database type.
6. Complete the remaining fields to specify the database for your system. Click the Help link to see individual field descriptions.
7. Select Test, and change or correct settings if necessary.
8. Select Save.
9. Click Main to view the JDBC Administration - Main screen.
10. Click the option button associated with the new DIPID.
11. Click Start to make the connection between the Avaya IR system and the MS SQL Server database.

© 2004 Avaya Inc. All Rights Reserved.