Installing the MS SQL 7.0 JDBC driver

Avaya Logo

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:

From a Web browser, go to the inetsoftware web site and locate the download links for the i-net Sprinta JDBC 2.0 API.
Download the .jar file or .zip file, and save it to a PC.
If the downloaded file is a .zip file, extract the .jar file from the .zip.
Transfer the .jar file (using the ftp command or some other method) to the /tmp directory on the Avaya IR system.
Log on to the Avaya IR system as root.
Enter cd /tmp to go to the directory that contains the .jar file.
Enter cp filename.jar /vs/java/jdbc/lib/sqlserver.jar to copy the .jar file to /vs/java/jdbc/lib directory of the Avaya IR system and to rename it as sqlserver.jar.
Enter ls /vs/java/jdbc/lib 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:

Enter /etc/init.d/tomcat stop
The system displays messages indicating that the Tomcat engine is stopped.
Enter /etc/init.d/tomcat start
The system displays messages indicating that the Tomcat engine is started.
Use a browser to access Avaya IR Web Administration and view the JDBC Administration - Main screen.
Click the Dipid of the data interface process (DIP) you want to administer.
The JDBC Administration - Edit screen for the selected DIP is displayed.
Select MS SQL Server as the Database type.
Complete the remaining fields to specify the database for your system. Click the Help link to see individual field descriptions.
Select Test, and change or correct settings if necessary.
Select Save.
Click Main to view the JDBC Administration - Main screen.
Click the option button associated with the new DIPID.
Click Start to make the connection between the Avaya IR system and the MS SQL Server database.