We setup a new server and installed Open Studio for Data Integration 6.3.1. We exported our old projects from DI 5.6 on a separate machine. We were able to import the projects into DI 6.3 but when we attempt to connect to any of the old SQL metadata connections we receive an error when checking the connection.
Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195) at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1092)
We have attempted with login/password and without ,with JTDS and Microsoft. We have copied the file ntlmauth.dll into all the usual places. We have added the JAVA_HOME and set the paths to jre1.8.0_101\bin. Any thoughts or hints would be appreciated.
Solved! Go to Solution.
From your error message, there is a missing jar issue(jtds-xxx.jar).
Have you already installed the external required jar file for Data Integration 6.3.1?
Have you tried to restart your studio after install the external jar file(jtds-1.3.1)?
Did you install proper - ntlmauth.dll? (32/64 bit)?
Yes, We restarted Studio and we re-copied the ntlmauth.dll just to make sure we chose the correct version. We are still getting the same error.
I tried downloading and installing all the modules available but we are still getting the same error on our SQL DB connections. Is there anything else we can attempt before we uninstall?