Updating jdbc drivers windows server 2016 enterprise edition
In previous versions of Business Objects a packaged Data Direct Driver was available for use.However with the release of BI 4 a licensed driver must be purchased for that driver.Additionally, a similar driver for Java (JDBC) has been released and both are available today.The Microsoft JDBC Driver 4.0 for SQL Server is JDBC 4.0 compliant and runs on the Java Development Kit (JDK) version 5.0 or 6.0.
Follow these steps to install the Windows driver for Apache Drill: Download: To get the previous driver version, go to the Apache Drill website and download the Map R Drill ODBC driver, version 220.127.116.119, for your environment: Map R_Drill_1.3_32or Map R_Drill_1.3_64
The 4.1 version works with Microsoft SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, and SQL Azure from any Java application, application server, or Java-enabled applet and provides application program interfaces (APIs) for Java Platform, Enterprise Edition 5, 6, and 7.
Version 3.1 of the PHP driver requires Microsoft ODBC Driver 11 (or higher) for SQL Server.
The best scenario is to use a short naming schema, since Long name sequences and special characters or spaces may end up creating problems.
Both the Windows and Linux jar file have an identical naming scheme.