SQL Server Driver not coming in Database Driver dropdown

Hi,

I am trying to connect to SQL Server from Knime version 3.2. I have followed the steps as mentioned in thread for installing SQL driver.

https://tech.knime.org/forum/knime-users/sql-server-connectivity

But, i am not able to get the SQL Server driver in the dorndown in Database Reader node.

Following is the error found in Knime.log

2016-08-17 23:36:36,396 : DEBUG : ModalContext : DatabaseDriverLoader : KNIME_project : 0 : Could not load JDBC ODBC driver class 'sun.jdbc.odbc.JdbcOdbcDriver'. Class has been removed in Java 8.

Can somebody please help to correct this?

Thanking You,

Bhavin Shah

There isn't a native driver in KNIME for SQL server. You need to download the jdbc driver from microsoft. I have a feeling this is the link (https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774), there are different versions, try tehm until you find one that works. We are using sqljdbc_4.2\enu\sqljdbc4.jar

After you've downloaded the driver, place it in a folder and then in the KNIME Analytic Platform go to File -> Preferences -> KNIME -> Database. Click on the Add file and pick the jar file.

After this, it should appear in the database driver choices. Ours come out as com.microsoft.sqlserver.jdbc.SQLServerDriver

Best

David