Installing the MS SQL 2000 JDBC driver

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

To download the JDBC driver for MS SQL Server 2000:

1. From a Web browser, go to the Microsoft downloads page.
2. For the Product/Technology, use the search term SQL Server with the keyword jdbc.
3. Select the most recent driver. It should be SQL Server 2000 Driver for JDBC Service Pack 2 or later.

   The package information page is displayed. It provides links to the available drivers.

4. Select the .tar file for Solaris systems, for example mssqlserver.tar, and save it to the /tmp directory on the Avaya IR system.

   If you cannot directly download the file to the Avaya IR system, download it to a temporary location. Then transfer the file (using the ftp command or some other method) to the /tmp directory on the Avaya IR system.

To unpack and copy the driver files to the required location on the Solaris system:

1. Log on to the Avaya IR system as root.
2. Enter cd /tmp to go to the directory that contains the .tar file.
3. Enter mkdir install_mssql to create a directory for the contents of the .tar file.
4. Enter mv mssqlserver.tar install_mssql to move the .tar file into the install_mssql directory.
5. Enter cd install_mssql to go to the install_mssql directory.
6. Enter tar xvf mssqlserver.tar to unpack the mssqlserver.tar file.
7. Enter ./install.ksh to run the installation script.

   The installation script runs and displays the license agreement when you press Enter.

8. Press Enter to view the license agreement, and press the spacebar to view additional lines of the license agreement.
9. At the bottom of the license agreement, press Enter to accept the license.
10. At the installation directory prompt, type /tmp/install_mssql and press Enter.
11. When the confirmation message is displayed, enter cd lib to go to the /tmp/install_mssql/lib directory.
12. Enter cp *.jar /vs/java/jdbc/lib to copy the .jar files to /vs/java/jdbc/lib directory of the Avaya IR system.
13. Enter ls /vs/java/jdbc/lib to display the lib directory contents and to verify that the three ms*.jar files were successfully copied.
14. To remove the install_mssql directory, enter cd /tmp to go to the temp directory, and enter rm -rf /tmp/install_mssql to remove the install_mssql directory and its contents.

To install the MS SQL Server 2000 JDBC driver:

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. Use the following settings:
   • Port number can remain the default value.
   • Database type is Custom.
   • Classname is com.microsoft.jdbc.sqlserver.SQLServerDriver.
   • Database URL is jdbc:microsoft:sqlserver://domain_name:1433;databaseName=yourdatabasename where domain_name is the domain name for the MS SQL Server 2000 server, and yourdatabasename is the filename of the database.
   • Additonal properties can be left blank.
   • Connection Pool Size is the maximum anticipated number of concurrent JDBC connections that the IVR implementation will use.
   • Database subtype is Microsoft SQL Server.

6. Select Test, and change or correct settings if necessary.
7. Select Save.
8. Click Main to view the JDBC Administration - Main screen.
9. Click the option button associate with the new DIPID.
10. Click Start to make the connection between the Avaya IR system and the MS SQL Server database.

© 2006 Avaya Inc. All Rights Reserved.