SQL Server Microsoft JDBC Drivers

The SQL Server (v6.1) drivers included with Aqua Data Studio work across all versions of Microsoft SQL Server. Microsoft SQL Server releases are very frequent, and may sometimes require updating the JDBC driver.

Contents

• Driver Location
• Updating Driver Contents for use with Microsoft SQL Server
• Known limitations of Microsoft JDBC Driver

Driver Location

You may locate the latest Microsoft SQL Server JDBC drivers at the following location

Vendor: Microsoft
Driver URL: https://msdn.microsoft.com/library/mt484311.aspx
Database Product: Microsoft SQL Server

Updating Driver Contents for use with Microsoft SQL Server

To update the Aqua Data Studio JDBC drivers for Microsoft SQL Server you need to overwrite the Aqua Data Studio sqljdbc42.jar file. Below is a listing of the Aqua Data Studio library directory [ADS_INSTALL]\lib\drivers\ ...

Windows

[ADS_INSTALL]\lib\drivers\sqljdbc42.jar

C:\Program Files\Aqua Data Studio 18.0 - 64bit\lib\drivers>dir
 Volume in drive C has no label.
 Volume Serial Number is 4414-4270

Directory of C:\Program Files\Aqua Data Studio 18.0 - 64bit\lib\drivers>dir

29-11-2016  15:49    <DIR>          .
29-11-2016  15:49    <DIR>          ..
14-07-2016  16:29            15,364 cassandra-clientutil-extras.jar
14-07-2016  16:29            36,549 cassandra-clientutil.jar
14-07-2016  16:29           228,286 cassandra-jackson-core-asl.jar
14-07-2016  16:29           765,648 cassandra-jackson-mapper-asl.jar
14-07-2016  16:29         1,073,177 cassandra-thrift.jar
14-07-2016  16:29         1,146,367 db2java.jar
14-07-2016  16:29         3,670,726 db2jcc.jar
14-07-2016  16:29             1,015 db2jcc_license_cu.jar
14-07-2016  16:29         3,103,132 derby.jar
14-07-2016  16:29           583,719 derbyclient.jar
14-07-2016  16:29           266,316 derbynet.jar
14-07-2016  16:29           194,265 google-api-client.jar
14-07-2016  16:29            94,470 google-api-services-bigquery-v2.jar
14-07-2016  16:29             6,720 google-http-client-jackson2.jar
14-07-2016  16:29           286,717 google-http-client.jar
14-07-2016  16:29            10,914 google-oauth-client-java6.jar
14-07-2016  16:29             5,935 google-oauth-client-jetty.jar
14-07-2016  16:29            61,092 google-oauth-client.jar
14-07-2016  16:29        17,419,588 hive-exec.jar
14-07-2016  16:29            91,129 hive-jdbc.jar
14-07-2016  16:29         5,125,422 hive-metastore.jar
14-07-2016  16:29         1,865,760 hive-service.jar
14-07-2016  16:29           963,515 ifxjdbc.jar
14-07-2016  16:29         2,014,423 jconnect16.jar
14-07-2016  16:29           539,912 jetty-6.jar
14-07-2016  16:29           177,131 jetty-util.jar
14-07-2016  16:29         4,736,151 jt400.jar
14-07-2016  16:29           549,628 jtds-src.jar
14-07-2016  16:29           372,788 jtds.jar
14-07-2016  16:29         1,898,476 mongo.jar
14-07-2016  16:29           651,205 mysql-src.jar
14-07-2016  16:29           867,335 mysql.jar
14-07-2016  16:29         2,714,189 ojdbc6.jar
14-07-2016  16:29         1,656,248 orai18n.jar
14-07-2016  16:29           415,357 paraccel-jdbc.jar
14-07-2016  16:29        38,354,188 phoenix.jar
14-07-2016  16:29           561,969 postgresql.jar
14-07-2016  16:29         1,713,721 redshift.jar
14-07-2016  16:29         6,623,425 sqlite-jdbc.jar
14-07-2016  16:29           653,574 sqljdbc42.jar
14-07-2016  16:29           287,555 util400.jar
14-07-2016  16:29         9,038,592 voltdb.jar
14-07-2016  16:29           262,740 xdb6.jar
14-07-2016  16:29         1,420,339 xmlparserv2.jar
14-07-2016  16:29           779,974 zookeeper.jar
              45 File(s)    113,304,746 bytes
             2 Dir(s)  30,545,129,472 bytes free
C:\Program Files\Aqua Data Studio 18.0 - 64bit\lib\drivers>dir

Linux

[ADS_INSTALL]/lib/drivers/sqljdbc42.jar

OSX

Aqua Data Studio.app/Contents/Java/drivers/sqljdbc42.jar

The Java class path for the drivers are already configured for ADS in the datastudio.ini for launching ADS with datastudio.exe and in datastudio.bat/.sh and datastudio-bundled.bat/.sh for launching Aqua Data Studio from the command line.

Known limitations of Microsoft JDBC Driver

• Windows Authentication not supported. You can authenticate using SQL Server Authentication or Windows Single Sign-On.
• The SQL Server sql_variant data type is not supported.