Skip to Content
Mobile

Installing and creating a connection to Microsoft SQL using JDBC in SUP 2.x

Tags:
Installing and creating a connection to Microsoft SQL using JDBC in SUP 2.x

This technical document explains how to install the Microsoft JDBC driver and configure
a connection to the Microsoft SQL Server in SUP.

Required Software

1.            SUP 2.x.x or higher
2.            Microsoft JDBC 4.x drivers

Assumption

This document assumes you have a working SUP environment.
You need to have access to a Microsoft SQL Server.
You need to have JDBC 4.x Drivers from Microsoft.

Step 1 – Adding the MICROSOFT DRIVER to the SUP envirement:

a.    User needs to manually install the Microsoft driver in order for Workspace and SUP server to consume them.

Solution

In order to add the Jar files for Microsoft SQL Server, you need to down load them and have access to the SUP Environment.
1.    Down load the JDBC drivers from Microsoft.
2.    Run the setup.exe file.
3.    You should have two JAR files and one DLL file see list below.
Once you download the drivers you should have a set of JAR file similar to the following list.
Ø  sqljdbc.jar.
Ø  sqljdbc_auth.dll.
Ø  sqljdbc4.jar.
4.   Copy the sqljdbc4.jar and sqljdbc_auth.dll file to the following locations sqljdbc.jar should not be used.

Ø  C:\SAP\MobilePlatform\MobileSDK23\MobileWorkSpace\mobile\eclipse\plugins\com.sybase.uep.com.sqlserver_2.3.0.201301212158\lib

Ø  C:\SAP\MobilePlatform\Server\Unwiredserver\lib\3rdParty
5.    Once you are done with the copying of the files reboot your SUP server.
6.    Start the SUP Workspace.
7.    Go to the Enterprise Explorer.
8.    Right click on Database Connections and select New.
   Figure 1
9.    Configure the location of the Microsoft JDBC driver JAR file.
10.  Select the wheel icon to enter the menu.
11.  Select the Driver Temple that matches your Microsoft SQL version.
    Figure 2
12.  Select the JAR List TAB
13.  Click on the Clear ALL button
14.  Click on the Add Jar/ZIP… button.
  
   Figure 3
15.  Brows to the lib folder where you installed the JAR files.
16.  Select one jar and the DLL a time until you have selected the correct combination.
17.  For MS-SQL 2008 and up the combination is sqljdbc4.jar and sqljdbc_auth.dll.
18.  For MS-SQL 2000 and 2005 the combination is sqljdbc.jar and sqljdbc_auth.dll.

 
           Figure 4 This completes the install process for the Microsoft JDBC 4.x driver.

Step 2 – Creating the Microsfoft JDBC Connection:

User needs to add a Data source in order to connect to Microsoft SQL Server.

Solution

In order to do that, you need to do the following steps.
1.    Go to the Enterprise Explorer
2.    Right click on Database Connections and select New.
   Figure 5
3.         Drivers pull down menu select the Driver you install in the first steps
4.         Add your Database Name
5.         Add your Host name or TCP/IP address

    Figure 6

6. Add the port number for the MS-SQL Server it listening on
7. Add your User Name
8. Add your Password.

9. Click Finish

10. Click the Test Connection Button.
   Figure 7
This concludes the Data Source configuration of the Microsoft JDBC driver.

Step 3 – trouble shooting the MS-SQL JDBC driver connection:
a.    Unable to connect using the Microsoft JDBC drivers.

Solution

In order to get a clearer idea of what may be wrong we need to do the following steps.
1.    Check the locations where you copied the three JAR files and DLL.
2.    Make sure you have the correct combination to match your MS-SQL server version.
3.    Restart the SUP server and the Workspace.
4.    Open Workspace and go to Enterprise Explorer.
5.    Double click on the Microsoft Data source.
6.    Go to the Driver Properties.
7.    Go to and click on the triangle icon.
8.    Click on the JAR list tab make sure it is correct.
9.    Click on the Properties tab check the JDBC URL
10.  Check and make sure you only have one jar file insalled and not two.

Figure 8
This document explained in details the steps needed to install the Microsoft JDBC driver
and how to create a connection and  review on how to check the installed drivers.