
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to fix a wrong installation of mssql-jdbc.jar?
Hi @All,
I made a mistake during configuration of a talend instance for my team member. I configured a database connection in metadata and after clicking on test connection it will be install several jar-files from internet except the mssql-jdbc.jar. This file have to be installed manually by choosing a file from localhost. I have choosed the wrong JAR-file, because I get now an error message during test connection.
How can I remove the JAR-file and install the correct JAR-file. Is there a replace option or something else?
Greetings from Germany
InRe
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Sabrina, hello Lord-Vader,
thank you very much for your feedback.
I used Vaders Information to find the location of the installed driver, after then I renamed the folder name of mssql-jdbc and I re-started Talend Open Studio.
With next check via "test connection" button Talend detects the missing driver, the wizards starts and I had to choose the correct JAR-file.
Mission accomplished!
Greetings from Germany
In Re

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Download jdbc jar file:
https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc
Go to this folder location:
C:\Program Files (x86)\TOS_DI-8.0.1\studio\configuration\.m2\repository\org\talend\libraries
Look for a mssql-jdbc folder. Mine is something other because i use different versions. Add your version of downloaded jar file to the folder.
Now in talend go to window -> show view -> other -> modules and open it.
Now in the module window search for the mssql, you will get all the component that use it.(look at example image)
Now click on that 3 dotted button on the right. search for your jar file via the lookup.
You have to choose a custom MVN URI.
Set it something like this: "org.talend.libraries/mssql-jdbc/11.2.2/jar". My example is something else, but this will get you going.
Detect the module and then click ok.
Then just restart you talend and your done.
Hope this helps.
Vader Out 💪.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
You are able to override the current version of the driver by customizing its Maven URI
For more information, please have a look at this documentation:
Best regards
Sabrina

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Sabrina, hello Lord-Vader,
thank you very much for your feedback.
I used Vaders Information to find the location of the installed driver, after then I renamed the folder name of mssql-jdbc and I re-started Talend Open Studio.
With next check via "test connection" button Talend detects the missing driver, the wizards starts and I had to choose the correct JAR-file.
Mission accomplished!
Greetings from Germany
In Re

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Great your mission accomplished! Feel free to let us know if there is any further help we can give.
Best regards
Sabrina
