unable to connect to MS-SQL server

[ali_hijazi1]

Hello
I'm working on Talend Data Quality
I wanted to create a DB connection and I supplied the details (server, database name, user, pwd)
However when I click on the check button to check if the connection is successful i get that the file jtds-1.3.1-patch.jar is missing but the I cannot make any action as the action button is disabled
I went to Help->Install Additional Packages
I get that there is nothing to install

Please advise

[Anonymous]

Hi,
Have you already checked documents about: TalendHelpCenter:Identify required external modules and  TalendHelpCenter:Install external modules?
Best regards
Sabrina

[ali_hijazi1]

Yes I already did and I can't find Network Connections as per the help page

[ali_hijazi1]

could it be because I'm launching the 32-bit talend Data Quality and connecting to 64-bit data source
please advise as I'm unable to do anything

[Anonymous]

I also have the " jtds-1.3.1-patch.jar is missing" problem when trying to connect to SQL Server (2014) on Windows 10 using the data quality tool. I have searched many web sites and can not find this exact file to download, and the search feature in Talend did not find it or give any relevant information. The documentation did not help either. Please help.
NOTE: The following file can be found in the Talend Library but it has a slightly different name: C:\Users\Bill\.m2\repository\org\talend\libraries\jtds-1.3.1-patch\6.1.1-SNAPSHOT
Also, the extracted files and exe's remain in the Downloads folder. Shouldn't they be relocated to somewhere permanent?
This looks like a very nice tool and I would really like to get it working with SQL Server 2014.
Thanks.

[Anonymous]

Hi,
SQL Server 2014 is not list on the documents:

TalendHelpCenterupported databases for profiling data and TalendHelpCenterupported systems%2C databases and business applications by Talend components

Best regards
Sabrina

[Anonymous]

Hello,
I have encountred the same error.
I am using TOS Data Quality and TOS Data Integration (x86) with sql server 2014. I can only connect to database using TOS Data Integration ! when trying to do so using TOS DQ i get the "jtds-1.3.1-patch.jar" missing message with the action botton disabled (download and install).
I removed sql server 2014 and installed sql server 2012 but it's still not working.
can you help us please ? thank you

[Anonymous]

Hi,
For your missing jar  "jtds-1.3.1-patch.jar", have you already checked documents about:TalendHelpCenter:Identify required external modules and TalendHelpCenter:Install external modules?
Best regards
Sabrina

[Anonymous]

I have to say that i've read it quickly.
Now that i've read it thoroughly, i managed to resolve the problem.
Thank you Sabrina

[Anonymous]

I had encountered two problems. First error is missing the driver file. I solved it. The second one is when I input all the server name and login credentials, the error is :You must change the database setting. I don't know what's the problem is. Can anybody help?
 For those who are still struggling on the first issue, here is the solution: 
Find the driver in google and download it. The tricky thing is rename the driver with the same name the error message mentioned. jtds-1.3.1-patch.jar.