Download and install the driver for MS SQL Server

If a client wants to run SQL Server as their mobile server database, then they need to download the driver for MS SQL Server.

About this task

The driver provides Java database connectivity from any Java application, application server, or Java-enabled applet. This driver is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs).

Procedure

  1. Visit the Microsoft Developer Network site. https://msdn.microsoft.com
  2. Search the site for Microsoft JDBC Driver for SQL Server.
  3. Click Microsoft JDBC Driver for SQL Server.
  4. On the resulting page, click Download the Microsoft JDBC Driver 6.0 (Preview), 4.2, 4.1, or 4.0 for SQL Server.
  5. Select your language, and then click Download.
  6. Choose the download files you want according to your mobile server’s host environment.
  7. Click Next.
    The download should begin, and the completed download files should be in your usual downloads folder.
  8. To install the driver, stop Tomcat.
  9. Copy the downloaded sqljdbc4.jar file into the tomcat/webapps/<sis-mobileserver>/WEB-INF/lib folder on the web server.