Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-01-26 10:25 AM

[resolved] Error when creating connection to SQL*Server

I am getting an error when I try to configure a connection to SQL*Server in Open Studio for Data Quality version 6.1.
I tested by connection from Excel successfully, so the problem is Talend.
The message I receive is that I am missing the module jtds-1.3.1-patch. 
I believe I downloaded the jtds-1.3.1.jar but not sure why it is looking for the patch. and the patch.jar is not there.


Not sure what I need to do. The documentation does not directly address this problem.. Any suggestions?
Thanks,
ian
Labels (2)
Labels
565 Views
0 Likes
1 Solution

Accepted Solutions
Anonymous
Not applicable
‎2016-01-26 01:48 PM
Author

OK figured it out....
You do need the "patch" file. You can find it at: talend-update.talend.com/nexus/content/repositories/libraries/org/talend/libraries/jtds-1.3.1-patch/6.1.1/
I then copied it to the .../java/lib directory and things started working.

View solution in original post

565 Views
0 Likes
7 Replies
Anonymous
Not applicable
‎2016-01-26 01:48 PM
Author

OK figured it out....
You do need the "patch" file. You can find it at: talend-update.talend.com/nexus/content/repositories/libraries/org/talend/libraries/jtds-1.3.1-patch/6.1.1/
I then copied it to the .../java/lib directory and things started working.
566 Views
0 Likes
Anonymous
Not applicable
‎2016-01-27 04:20 AM
Author

Hi,
Thanks for sharing your solution and posting that you resolved it by yourself.
Best regards
Sabrina
565 Views
0 Likes
Anonymous
Not applicable
‎2016-01-27 11:23 AM
Author

I'm having the same issue - where did you find the /java/lib directory? When I installed Talend I downloaded the folder from the website and then unzipped and placed it in the C drive. I'm looking in that folder (C:\Talend\TOS_DQ-20151214_1327-V6.1.1) now and don't see a /java/ directory. Are you referring to /configuration/lib/java by chance? 
565 Views
0 Likes
Anonymous
Not applicable
‎2016-01-27 02:42 PM
Author

This is the exact link I used: https: //talend-update.talend.com/nexus/content/repositories/libraries/org/talend/libraries/jtds-1.3.1-patch/6.1.1/   (check the formatting as I am having trouble posting this link)
565 Views
0 Likes
Anonymous
Not applicable
‎2016-02-04 09:08 AM
Author

Great post.  I was having the same issue.  The link worked. 
I had to rename the file from jtds-1.3.1-patch-6.1.1.jar to jtds-1.3.1-patch.jar.  I put it in the \TOS_DQ-20151214_1327-V6.1.1\configuration\lib\java directory.  Then used the Modules view to manually add it to Talend by clicking on the Jar icon.  To see the Modules view, click  Window, Show View..., Talend, Modules.
565 Views
0 Likes
Anonymous
Not applicable
‎2016-03-15 05:14 PM
Author

Is there an alternate site for this file?  I am getting HTTP Error 500 when trying to access any file in the libraries directory.
565 Views
0 Likes
Anonymous
Not applicable
‎2016-03-16 09:18 AM
Author

Thanks, for fixing the website...
565 Views
0 Likes